Share via

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

Gustavo Bugança 0 Reputation points
2025-02-24T21:55:25.1333333+00:00

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

Microsoft 365 and Office | Office Online Server
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua 18,065 Reputation points Moderator
    2025-02-25T09:34:25.9433333+00:00

    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.

    0 comments
  2. Gustavo Bugança 0 Reputation points
    2025-02-25T11:20:59.3066667+00:00

    Hello,

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

    Y use this sheet on website of internet.

  3. Gustavo Bugança 0 Reputation points
    2025-03-01T13:49:43.0166667+00:00

    Ola,

    Esta planilha fica armazenada dentro do Share Point disponibilizado pela microsoft.

    0 comments
  4. Gustavo Bugança 0 Reputation points
    2025-03-06T18:49:10.7533333+00:00

    Boa tarde,

    Algum retorno ?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.