Weird pivot table errors

J

JohnC

Hi
I'm getting the following error form a pivot table that is mystifying me.
"The PivotTable name is not valid. To create a PivotTable report, you must
use data that is organised 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"

The source of the pivot table is another excel spreadsheet which has only
one column. The column is labelled correctly and until recently there was no
problem with this pivot table.

The weird thing is that is I open up the source data, the pivot table will
refresh with no issues. But if I close the file down then the pivot table
will have the same error again.

I have tried re-creating the table, deleting it etc, but still the same
issue remains, apart from when the source file is open. The same issue occurs
in other files pivot tables that reference this data.

Anyone got any ideas?

Regards
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Counting Text Data 0
Pivot Table cell values 1
Pivot table 0
The PivotTable field name is not valid (error) 1
Excel does not accept text format! 0
Slicers and Calculated Items in Pivot Table 2

Top