Forum Discussion
Solved
Pivot Table update data source
I need to use the same pivot table set up every month. I have not found a way to copy the pivot table set up and use a different page of data. I would prefer not to have to recreate the table every...
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?
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.
Glad you were able to get it working!