If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 Pivot Tables compatible with 2003
I am running Office 2003, but I have been sent pivot tables created by a
colleague in Excel 2007. The workbook is being saved as an *.xls, but when I try to click on the column headers in the pivot table, I get an error saying "this Pivot Table Report is not Valid". Does anyone have any suggestions how to address this issue? |
#2
|
|||
|
|||
Excel 2007 Pivot Tables compatible with 2003
This is based on a faulty memory, so you'll have to test it.
I _think_ you'll want to save the workbook as 97-2003 version before you build the pivottable. Then (reopen???) and build the pivottable. Jimmy G wrote: I am running Office 2003, but I have been sent pivot tables created by a colleague in Excel 2007. The workbook is being saved as an *.xls, but when I try to click on the column headers in the pivot table, I get an error saying "this Pivot Table Report is not Valid". Does anyone have any suggestions how to address this issue? -- Dave Peterson |
#3
|
|||
|
|||
Excel 2007 Pivot Tables compatible with 2003
The user who gave you rht document had to see this message when they saved:
"A PivotTable in this workbook will not work in versions prior to Excel 2007. Only PivotTables that are created in Compatibility Mode will work in earlier versions of Excel" In other words, it must be created in 2007 "compatibility mode", or it can't be used in 2003. Saving as xls doesn't work here. Go back to the source of the PT person & have them redo it (in 2003, if possible). Lastly, you may have to recreated it from within 2003 using the source data. "Jimmy G" wrote: I am running Office 2003, but I have been sent pivot tables created by a colleague in Excel 2007. The workbook is being saved as an *.xls, but when I try to click on the column headers in the pivot table, I get an error saying "this Pivot Table Report is not Valid". Does anyone have any suggestions how to address this issue? |
#4
|
|||
|
|||
Excel 2007 Pivot Tables compatible with 2003
Jimmy G;951305 Wrote: I am running Office 2003, but I have been sent pivot tables created by a colleague in Excel 2007. The workbook is being saved as an *.xls, but when I try to click on the column headers in the pivot table, I get an error saying "this Pivot Table Report is not Valid". Does anyone have any suggestions how to address this issue? the pivots created in excel 2007 version will not work in prior version. there are two options 1. ask you colleague to creat a pivot table in excel 2003 and give it to you. 2. yourself create similar pivot table in excel 2003 version by copying the data -- bala_vb |
Thread Tools | |
Display Modes | |
|
|