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