Forum Discussion
Solved
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 tabl...
Did you try to refresh PivotTables one by one, not by Refresh All?
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
Did you try to refresh PivotTables one by one, not by Refresh All?