Pivot Table Compatibility Issue from 97-2003 to 2010 version

purplegardener

New Member
Joined
Jun 22, 2005
Messages
31
Hello,

We have just switched over from Excel 97-2003 to Excel 2010 version and some of our pivot tables have the error message saying "a pivot table in this workbook will not work in versions prior to Excel 2007. Only Pivot Tables that are created in Compatibility Mode will work in earlier versions of Excel". Excel help says to save the workbook to excel 97-2003 format and then recreate the pivot table in compatibility mode. I've updated the data range and resaved the file, but the error message still appears. What are the steps to fix this issue?

Is it normal that an "!" appears next to the file icon when it is saved as a macro enabled workbook now?

Thanks for any assistance you can provide. Our IT is not trained to help us in this area.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Do you need them to work in versions prior to 2007? If you do, you have to do what the instructions say.

Yes, the exclamation mark is normal.
 
Upvote 0
Do you need them to work in versions prior to 2007? If you do, you have to do what the instructions say.

Yes, the exclamation mark is normal.




We do not need them to work in a prior version, as long as they still function in the 2010 version. I'm confused about the step saying to recreate the pivot table in compatibility mode. Where would I select this option?

Thanks for any help.
 
Upvote 0
You have to save the file as an .xls file (ie the old 97-2003 format) and then create the pivot table.
 
Upvote 0
No - older pivot tables will work in newer versions, but not vice versa.
 
Upvote 0
No - older pivot tables will work in newer versions, but not vice versa.

So if we have pivot tables that were created in the 97-2003 version, they will work in the 2010 version? Why do we need to re-save the file back as a 97-2003 file and then re-create the pivot tables? Won't we get the same error message when we convert the file again?
 
Upvote 0
What is the extension of the "current" file you are working in? xls or xlsx?
 
Upvote 0
? So what is it now....
It sounds like it is trying to maintain the previous version format. Changing the extension doesn't guarantee the conversion to the new format.
In the following link see the section "Convert a workbook to the Excel 2010 file format" (also applies for 2013.)
https://support.office.com/en-sg/article/use-office-excel-2010-with-earlier-versions-of-excel-2fd9ffcb-6fce-485b-85af-fecfd651a5ac#bm4
Since you indicate Macros exist in these workbooks, be careful and maintain a separate copy. I have not tested what happens to macros when converting files.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top