Share via

Error when using DETECTLANGUAGE for 50000 rows

Anonymous
2025-02-25T19:08:32+00:00

Hello

I am getting an error when trying to use the DETECTLANGUAGE function in excel. I have a column (column A) of 50000 rows of sentences and in the next column (column B) I am doing a detectlanguage of column A. It does about 1000 and then gives a #Connect! error. When I click the cell, it says "Request Throttled".

My questions are:

  1. What are the limits to using functions like these
  2. Is there a better way to accomplish this, such as power automate, excel online or something else?

Thank you

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-28T06:28:07+00:00

    The error means you have exceeded your daily quota of translation function.

    DETECTLANGUAGE function - Microsoft Support

    Is it possible to find out most of the language in other ways, and then solve the remaining small part with formulas?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-02-27T17:14:34+00:00

    I have, it goes for about 1000 entries and then I get the #CONNECT error with the "Request Throttled" message when you highlight the connect error.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-02-26T05:27:40+00:00

    Have you tried Detectlanguage for each cell separately?

    =Detectlanguage(A2) then fill it down.

    Was this answer helpful?

    0 comments