Hello all,
I have a large workbook with many different pivot tables derived from two different source lists.
I'm approaching completion of my project and want to update all links / PT's and when I go to refresh, a menu pops up saying
"The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field"
I don't understand this error message as I'm using the same PT's as before and hadn't experienced this problem.
Any help would be appreciated.
Thanks!
Bookmarks