Forum Discussion
The PivotTable field name is invalid error
I have a multi-tab workbook with 14 tables and even more PivotTables. I am getting the error: The PivotTable name is invalid on Data tab Refresh All. Since this error does not point to a certain table or pivot, how do I find the source of the error? I have gone through every table and pivot and cannot find a problem.
Thank you for any help.
Ken
Did you try to refresh PivotTables one by one, not by Refresh All?
7 Replies
Doesn't the error message say "The PivotTable field name is not valid"?
The most probable cause of that problem is that the data source of one of the pivot tables on the Data sheet has an empty column header, either because it was left empty, or because the data source contains too many columns.
You'll have to check that manually, I'm afraid.
HansVogelaar thank you for the reply. I have checked all of my data tables and pivot tables several times. This is the first I've heard of too many columns. How many is too many?
Ken
I meant that the data source includes empty columns to the right of the actual data.
