Share via

Excel Pivot Table calculation after refresh result in #NAME?

Anonymous
2018-03-14T21:31:25+00:00

I created a calculation in a pivot table.  When I refresh the pivot table the calculation results in the following:

It should be 

I do not want to have to recreate or correct the formula with each refresh.  Can someone please help?

Microsoft 365 and Office | Excel | For home | 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. Ashish Mathur 102K Reputation points Volunteer Moderator
    2018-03-18T00:29:16+00:00

    Hi,

    I believe you tried to paste an image there but it has not been pasted.  Please retry.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-03-17T14:01:40+00:00

    Hi Dydek,

    Feel free to share the information mentioned above for troubleshoooting when you have time.

    Regards,

    Tina

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-03-15T08:26:26+00:00

    Hi Dydek,

    To troubleshoot the issue, we'd like to confirm the following information:

    1.What is the formula do you use?

    Usually, the #NAME? error is generated when a cell tries to reference a non-existent cell. Please check if the formula you use is a valid formula.

    2.Go to Formulas tab>Calculation Options>choose Automatic

    Then check if the issue happens when you refresh the Pivot table.

    3.Please provide some related screenshots about symptom.

    Note: to protect your privacy, please mask any personal or private information in the screenshots before sharing.

    4.The version of Excel. You can check it via the steps in this article.

    5.Your operation system. (Windows or Mac)

    Regards,

    Tina

    Was this answer helpful?

    0 comments