ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unable to 'Change Data Source' on Pivot Table (https://www.excelbanter.com/excel-programming/454179-unable-change-data-source-pivot-table.html)

[email protected]

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 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com