Refreshing 2003 Pivot Table w/ Excel 2007

F

FloydN

I have a pivot table created with Excel 2003. The source data for the pivot
table is an Access 2003 database query. When I open the 2003 workbook in
Excel 2007, it opens in compatibility mode as expected. When I refresh the
pivot table and attempt to save the workbook, I receive the following note
from the compatibility checker:

A PivotTable in this workbook exceeds former limits and will be lost if
saved to an earlier format. Only PivotTables created in Compatibility Mode
will work in earlier versions of Excel.

This confuses me because I am in compatibility mode when I save the
workbook. My other legacy pivot tables do not have this issue. On top of
that, if I get my colleague who hasn't been upgraded to Office 2007 yet to
open the workbook, refresh the pivot table, and save it, there are no errors
or problems with the pivot table. If some limit is being exceeded, as the
note above suggests, then I would think that he would encounter some issue.

Help me please. Until everyone I work with is upgraded to 2007, these
workbooks must remain in 2003. Hopefully we are talking about weeks not
months.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table cell values 1
Pivot table overlaps another pivot table - how to find it 0
Formula to Look up values from a pivot table 1
Pivot Table Counting Text Data 0
Pivot Tables 2003 v 2007 0
Excel 2007 pivot table using analysis services cube as data source 0
Refreshing a pivot table 1

Top