• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Calculated Fields do not update after refresh

A

AlanD

New Member
Hi Everyone

I am new to the forum and new to Pivot Tables

I have a pivot table with calculated values. I have found it neccessary to change some of the header columns names in my data source. After doing this and refreshing the pivot table I get a #Name error where calculated fields draw data from the newly labelled data source columns. This means that I have to re-create all the calculated fields with the new name. Does someone have a VBA code which can update the calculated fields automiatically? I am not proficient at writing code.

THanks in anticipation

AlanD
 
You must log in or register to reply here.
Back
Top