Pivot Table Problem between 2003 and 2007 (and back again)...

Lidsavr

Active Member
Joined
Jan 10, 2008
Messages
322
Help!

I have a file with multiple pivot tables in it. The file and pivot tables were created using Excel 2003. The file was opened in 2007 and was modified, but saved all along as a 97-2003 file to keep the data integrity for 2003 users in the company (while I was working on it). The only thing that was changed was some data was added to the "Raw Data" worksheet & the pivot tables were refreshed.

The modifications are done, but I am getting a compatability error on the pivot tables. The error says they were created as 2007 pivot tables. I know these were created in 2003, because my company is in the process of upgradeding to Office 2007 (I was recently upgraded) and I created the file using Excel 2003. I suspect that the program converted the tables when I opened the file (I can't think of anything else since the file still says "Compatibility Mode" on the Window bar at the top)

Is there a option in 2007 that I can set to tell the file that these are 2003 tables, or is all hope lost and I need to create a new file?

Any help is appreciated!

Thanks,

Lidsavr
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,132,679
Messages
5,654,712
Members
418,149
Latest member
tjanok

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
Top