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!