Meu Excel do Office 365 não tem a função "PROCX", como resolver ?

Question

Meu Excel do Office 365 não tem a função "PROCX", como resolver ?

Benoni Braga 0

Tenho um planilha Excel que uso no meu serviço, e ela contém a função PROCX, mas no meu Office 365 da minha assinatura da Microsoft, que eu uso em casa, essa mesma planilha da erro nas células que usam essa função, ela nem existe na lista de funções, será que a versão do Excel da minha assinatura está desatualizada ?

0 comentários

1 resposta

Sua resposta

Answer 1

Hi Benoni,

Microsoft introduces new functions gradually, and older versions don’t receive these updates. That’s why the same file behaves differently across environments.

the error occurs when:

Excel version difference PROCX/XLOOKUP is only available in Microsoft 365 (latest updates) and Excel 2021. If your home setup is running Excel 2016, 2019, or older, this function simply doesn’t exist there.

Updates not applied Even with Microsoft 365, if updates are paused or delayed, new functions won’t appear until you update.

Language mismatch The function name changes by language:

Portuguese: PROCX

English: XLOOKUP If your home Excel is in English, using PROCX will cause errors.

What you can try is:

Check your version Go to File → Account → About Excel. If it says Excel 2016 or 2019, you’ll need to upgrade to Microsoft 365 or Excel 2021 for PROCX/XLOOKUP support.

Update Office In File → Account → Update Options → Update Now to get the latest features.

Adjust the formula name If your home Excel is in English, replace PROCX with XLOOKUP.

Let me know how it goes, Happy to help!