Fórmula "PIVOTAR" esta alterando automaticamente a função da mesma com "_xleta."

Question

Boa tarde,

Estou com dificuldades em minha planilha, aonde a fórmula "pivotar" esta alterando de maneira automática e transformação a função da mesma com os caracteres de "_xleta." e desta forma a minha formula deixa de funcionar.

Ex: Formula correta:
=PIVOTAR(Base!B3:B50000;;Base!I3:I50000;SOMARPRODUTO;0;0;2;;;(Base!C3:C50000="Ativo")*(Base!I3:I50000<>"Vencido"))

Ex. Formula alterada automaticamente:
=PIVOTAR(Base!B3:B50000;;Base!I3:I50000;_xleta.SUMPRODUCT;0;0;2;;;(Base!C3:C50000="Ativo")*(Base!I3:I50000<>"Vencido"))

Favor auxiliar

Answer 1

Hi @Gustavo Bugança

It seems that the translator cannot translate the formula name you used very well.

What formula is "PIVOTAR" that you're using? Is it customized by you or comes with Excel?

Besides, are you using Microsoft 365 Apps?

Please check your data to see if there have been any changes.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

Hello,

The formula is Pivotby, it's disponible in Excel 365 for me.

Y use this sheet on website of internet.