Can't insert PIVOT table after deleting worksheet with previous PIVOT table on it

rod531

New Member
Joined
Apr 3, 2023
Messages
7
Office Version
  1. 365
Platform
  1. Windows
Hello. I have a worksheet with my raw data on. I successfully created two PIVOT tables on new worksheets. I then deleted the worksheets with the PIVOT tables on because I wanted to start afresh. Excel won;t let me insert a new PIVOT table now. I get the error message "The PIVOTTable field name is not valid. To create a PIVOT Table report, you must use data that is organised as a list etc" That error messages seems irrelevant and wrong - my data was fine for a PIVOT table before, I haven;t changed it. It is simply that I deleted a worksheet with a PIVOT table on. I am bewildered. Thanks in advance for any insights you may have. My issue has nothing to do with columns or column headers or lists or empty headers.
 
OK. Sorted. Thank you Rory for your help.
In the end it was a column header with a value in it rather than text.
My first draft of the file just had text headers. I created my first two PIVOT tables from that.
I then needed a new cell of reference data and I stuck it in a header cell and I inserted some more columns too.
If I left the PIVOT tables there, I could add new ones, but when i deleted them I got the error message.
AFter your last reply I noticed that the column totals were wrong between the raw data and the PIVOT table.
Sorted now.
Thanks for your input. Cheers, Rod
 
Upvote 0

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Thanks. Sorted. Thank you for your insights Rory. Much appreciated.
The issue in the end was indeed an invalid column header.
When I first created the file it was all text headers. I now realise that in between versions I needed a new reference data field and I foolishly put in a header cell.
I have now dragged it elsewhere and the file works ok.
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,250
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top