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.
 
Top