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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can't insert PIVOT table after deleting worksheet with previous PIVOT table on it
- Thread starter rod531
- Start date
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
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
Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.
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
