Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel2007 Pivot Table problem
I have an Excel2007 workbook containing a table. I created a pivot table on a
new worksheet and tested it and everything works great. I saved the workbook as both a 2003 and 2007 workbook. When I open the 2003 workbook in Excel2003, it opens. When I open the 2007 workbook in Excel2003, I get the conversion progress bar and then the workbook opens. In both workbooks when I click on one of the arrow buttons to filter the pivot table, nothing happens. The pivot table is frozen. I get a dialog stating that it was created in a later version and can not be modified. It was my understanding that the comptablility pack would allow Office2003 applications to work with Office2007 files. is this true? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel2007 Pivot Table problem
If you create the pivot table in Excel 2007 format, it will be read only
in earlier versions of Excel. If you create the pivot table while in compatibility mode in Excel 2007, it will be functional in earlier versions. schildb wrote: I have an Excel2007 workbook containing a table. I created a pivot table on a new worksheet and tested it and everything works great. I saved the workbook as both a 2003 and 2007 workbook. When I open the 2003 workbook in Excel2003, it opens. When I open the 2007 workbook in Excel2003, I get the conversion progress bar and then the workbook opens. In both workbooks when I click on one of the arrow buttons to filter the pivot table, nothing happens. The pivot table is frozen. I get a dialog stating that it was created in a later version and can not be modified. It was my understanding that the comptablility pack would allow Office2003 applications to work with Office2007 files. is this true? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Problem | Excel Worksheet Functions | |||
Pivot Table Problem | Excel Worksheet Functions | |||
Problem with Histogram function of EXCEL2007 BETA | Charts and Charting in Excel | |||
Pivot table problem | Excel Discussion (Misc queries) | |||
Pivot table problem | Excel Discussion (Misc queries) |