Pivot Table Error in 2007 - missing data when refreshed

  • Thread starter Thread starter el_guapo
  • Start date Start date
E

el_guapo

I have a complex forecast file with several pivot tables, saved as a version
2003. When I refresh the pivot tables in Excel 2007, it seems to only include
a portion of the data range in the calculation. No number of refreshes will
fix this.

When I calc it again in Excel 2003, it returns the correct results - no
other changes needed.

Any experience with this? Seems like a deal breaker if I can't trust the
pivot tables to work...

Thx
 
el_guapo said:
I have a complex forecast file with several pivot tables, saved as a version
2003. When I refresh the pivot tables in Excel 2007, it seems to only include
a portion of the data range in the calculation. No number of refreshes will
fix this.

When I calc it again in Excel 2003, it returns the correct results - no
other changes needed.

Any experience with this? Seems like a deal breaker if I can't trust the
pivot tables to work...

Thx
Click to expand...

When creating the pivot table use named ranges vs selecting your data area.

I opened the original file using excel 03, I named the data area as
“raw_dataâ€. I then modified the pivot tables to base off of that named range.
Then opened the same file using my excel 07 and it had the correct totals.

When Microsoft is doing the conversion from 03 to 07 it is losing the data
range, but by having it named we are forcing the system to retain the data as
we intended and getting correct totals.

For files that you can not modify in 03, if you will modify your pivot
tables to have a named range they will refresh with the correct totals.
 
Back
Top