Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table in Excel 2007
We are transitioning from Office 2003 to Office 2007 and doing it in
sections. However during this transition time and in the future when certain documents are brought back to life, we have an issue with Excel 2003 documents in Excel 2007. We've come across a couple Pivot Tables that work as expected in 2003, but once opened in 2007 they don't appear at all. We've tried a few different methods of trying to get the file to up-convert to 2007 and still work. I do realize that pivot tables have their own versioning in the files but why would this prevent viewing on 2007? My question is, what is the proper method for up-converting to 2007? Are Pivot Tables known issues for this? Are there work arounds? Thank you for your time. Kirk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table in Excel 2007
It should work without issue What are you experiencing? Is it difficult to
rebuild the PT from scratch if you need to (and yes, you shouldn't need to!) Does the PT exist on its own sheet or on the same sheet as the source data? Is it from an external source? "Kirk" wrote in message ... We are transitioning from Office 2003 to Office 2007 and doing it in sections. However during this transition time and in the future when certain documents are brought back to life, we have an issue with Excel 2003 documents in Excel 2007. We've come across a couple Pivot Tables that work as expected in 2003, but once opened in 2007 they don't appear at all. We've tried a few different methods of trying to get the file to up-convert to 2007 and still work. I do realize that pivot tables have their own versioning in the files but why would this prevent viewing on 2007? My question is, what is the proper method for up-converting to 2007? Are Pivot Tables known issues for this? Are there work arounds? Thank you for your time. Kirk |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table in Excel 2007
Well, as I investigated your questions, I stumbled across how to do this.
What I was looking for was under the "Analyze" tab and "PivotChart Filter." This is where the dropdowns went to. Sorry for the noise, just a bit of confusion. Kirk "Bob Umlas" wrote: It should work without issue What are you experiencing? Is it difficult to rebuild the PT from scratch if you need to (and yes, you shouldn't need to!) Does the PT exist on its own sheet or on the same sheet as the source data? Is it from an external source? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table in Excel 2007
Hi Kirk,
Is it possible to elaborate on your "....Analyze tab.....Filter." solution? I have the same problem and cannot find the "Analyze" tab . Appreciate any help... tks J. "Kirk" wrote: Well, as I investigated your questions, I stumbled across how to do this. What I was looking for was under the "Analyze" tab and "PivotChart Filter." This is where the dropdowns went to. Sorry for the noise, just a bit of confusion. Kirk "Bob Umlas" wrote: It should work without issue What are you experiencing? Is it difficult to rebuild the PT from scratch if you need to (and yes, you shouldn't need to!) Does the PT exist on its own sheet or on the same sheet as the source data? Is it from an external source? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Excel 2003 & Excel 2007 | Excel Worksheet Functions | |||
how do I refresh in excel 2007 a 2003 pivot table? | Excel Discussion (Misc queries) | |||
grouping error in Excel 2003/2007 Pivot table connect to offline c | Excel Worksheet Functions | |||
Excel 2007 pivot chart/table copying vs Excel 2003 | Charts and Charting in Excel | |||
Excel 2007 pivot table formats that work with 2003 | Excel Discussion (Misc queries) |