| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables range valued upon save in Excel 2007
Occassionally when I save and close a file, all of the pivot tables get range
valued and cannot be modified anymore when I reopen a file. I only started getting this problem when I switched over to Excel 2007. Anybody know what is going on? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot tables range valued upon save in Excel 2007
Brad
If you save the file as XL97-2003 format this will happen if you have used any of the new PT features of XL2007, you should get the compatibility feature though. Is this a native xlsx or an old xls? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "brad" wrote in message ... Occassionally when I save and close a file, all of the pivot tables get range valued and cannot be modified anymore when I reopen a file. I only started getting this problem when I switched over to Excel 2007. Anybody know what is going on? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot tables range valued upon save in Excel 2007
I am saving it in the old format. I didn't think I was using any of the new
PT features and it doesn't seem to happen consistently. I'll try converting to the new format and see if this goes away. Thanks. "Nick Hodge" wrote: Brad If you save the file as XL97-2003 format this will happen if you have used any of the new PT features of XL2007, you should get the compatibility feature though. Is this a native xlsx or an old xls? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "brad" wrote in message ... Occassionally when I save and close a file, all of the pivot tables get range valued and cannot be modified anymore when I reopen a file. I only started getting this problem when I switched over to Excel 2007. Anybody know what is going on? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 pivot tables in 2003 | Excel Discussion (Misc queries) | |||
| Bug with pivot tables corrupting in Excel 2007 | Excel Discussion (Misc queries) | |||
| 2007 Excel Pivot Tables - turn off subtotals | Excel Discussion (Misc queries) | |||
| Excel 2007 charting errors with pivot tables | Charts and Charting in Excel | |||
| Excel 2007 Error Reopening Pivot tables | Setting up and Configuration of Excel | |||
Linear Mode
