Pivot tabel field name not valid in 2007, was in 2003

K

KMiles

I have a workbook created in 2003. When I refresh pivot tables within in
2003, all is fine. When I open in 2007 and refresh, I get the "pivot table
field name not valid" error. There are no problems with columns missing
headers.

I can solve it by changing the data source, but I've got thousands of pivot
tables to update.
 

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

The PivotTable field name is not valid (error) 1
Excel 2013 Pivot Data Range formula reference problem 0
Pivot table report invalid 0
Embedded Excel into Word with Tables 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Tables 2003 v 2007 0
Refreshing 2003 Pivot Table w/ Excel 2007 0
Reference is not valid for Pivot tables 2

Top