Forum Discussion
Pivot Table update data source
This usually means there is a cell in your header range that is empty or blank. Are there hidden columns that have blank or empty cells in them?
Carol-
I think you just need to update the data source of the pivot table.
1. Copy and paste pivot from previous month
2. Go to the Contextual Tab called PivotTable Tools > Analyze > Change Data Source
3. Then update the range to pull from the new data set
Thank you for the quick help.
However, I keep getting a block that says a Field Name is invalid. I have tried every way I can think of to choose the data, but I continually receive that message. I MUST be missing something.
Any suggestions?
This usually means there is a cell in your header range that is empty or blank. Are there hidden columns that have blank or empty cells in them?
Woo Hoo, success!
From the social services sector, I thank you.
