Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table converts to text
We have a problem with pivot tables which is becoming quite troublesome. We
have a excel spreadsheet which includes a large datatable and we summarise the data using a pivot table. Often, this pivot table will convert itself to a text block - i.e. it looses all the properties of a pivot table and just shows the last answer. We then have to redo the pivot table. Several people use the spreadsheet (although not simultaneously) - the only possible explanation I have looked at is that one user is using Excel 2007 whilst the rest of us are still on 2003. We never had these issues prior to the Excel 2007. Has anyone else had this issue? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table converts to text
Hi
You need to get the XL2007 user to save it in XL97-2003 compatibility mode. Provided you do, this you can work on it as a Pivot table in both versions. When it goes through the File Conversion process from 2007 to 2003, what you describe usually occurs. -- Regards Roger Govier "Markish" wrote in message ... We have a problem with pivot tables which is becoming quite troublesome. We have a excel spreadsheet which includes a large datatable and we summarise the data using a pivot table. Often, this pivot table will convert itself to a text block - i.e. it looses all the properties of a pivot table and just shows the last answer. We then have to redo the pivot table. Several people use the spreadsheet (although not simultaneously) - the only possible explanation I have looked at is that one user is using Excel 2007 whilst the rest of us are still on 2003. We never had these issues prior to the Excel 2007. Has anyone else had this issue? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table converts to text
Thanks for this Roger - the 2007 user already uses the XL97-2003
compatibility mode yet still has these problems - is there a likely cause to this? "Roger Govier" wrote: Hi You need to get the XL2007 user to save it in XL97-2003 compatibility mode. Provided you do, this you can work on it as a Pivot table in both versions. When it goes through the File Conversion process from 2007 to 2003, what you describe usually occurs. -- Regards Roger Govier "Markish" wrote in message ... We have a problem with pivot tables which is becoming quite troublesome. We have a excel spreadsheet which includes a large datatable and we summarise the data using a pivot table. Often, this pivot table will convert itself to a text block - i.e. it looses all the properties of a pivot table and just shows the last answer. We then have to redo the pivot table. Several people use the spreadsheet (although not simultaneously) - the only possible explanation I have looked at is that one user is using Excel 2007 whilst the rest of us are still on 2003. We never had these issues prior to the Excel 2007. Has anyone else had this issue? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converts number to text(in English words) | Excel Discussion (Misc queries) | |||
number converts to text | Excel Worksheet Functions | |||
text in a pivot table | Excel Discussion (Misc queries) | |||
Pivot table converts data to a 1,2,3 how do I get data to correct | Excel Discussion (Misc queries) | |||
Using Excel converts number to english text | Excel Worksheet Functions |