Excel Says "Reference Not Valid" When Refereshing Pivot Tables

Here's a good succinct article about the Reference Not Valid error seen when refreshing Excel pivot tables. It explains what causes it and how to fix.

One thing to try that wasn't listed in the article -- if you have only a few pivot tables, copy each one's source data to a new table/range and give it a new name.  Change the Data Source for the pivot to the new table/range.  Refresh.  That has worked for me.  Admittedly, this might not be a great idea if you have lots of tables.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.