Unable to 'Change Data Source' on Pivot Table
I have a pivot table that I've updated each month for a few years and now I get and error message when I try to 'Change the Data Source":
"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 have not changed anything on this report, and don't understand why this message pops up and prevents me from 'Changing the Data Source' which is merely adding a few more rows!!! If anyone can shed some light on this I'd appreciate learning how to fix this. Thank you, Rob |
All times are GMT +1. The time now is 08:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com