Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 to Excel 2003 bug?
I have an Excel 2007 spreadsheet with a Pivottable in it.
I want to give it to a person that has Excel 2003. I have saved the spreadsheet in an Excel 2003 compatible file and given it to the other person. When they open it, it will not let them refresh the Pivottable when data is changed. the "Refresh" button is greyed out and we get a message about it being created in a different version. Is this a bug? Anyone have any suggestions or workarounds or words of wisdom here. Thanks for any help Dennis |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 to Excel 2003 bug?
The following appears to work for me. Try it and I will be interested in your
results. Before creating the Pivot Table save the workbook as xl97-2003 type file. Close the workbook (This is essential) Open the workbook again and it should be in compatibility mode (See the file name at the top of the workbook) Create the Pivot table and then save it again. I have tested the above with a simple pivot table and it opened O.K. with the pivot table in xl2002. -- Regards, OssieMac "Irvine, Dennis" wrote: I have an Excel 2007 spreadsheet with a Pivottable in it. I want to give it to a person that has Excel 2003. I have saved the spreadsheet in an Excel 2003 compatible file and given it to the other person. When they open it, it will not let them refresh the Pivottable when data is changed. the "Refresh" button is greyed out and we get a message about it being created in a different version. Is this a bug? Anyone have any suggestions or workarounds or words of wisdom here. Thanks for any help Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Excel 2007 pivot chart/table copying vs Excel 2003 | Charts and Charting in Excel | |||
Linked text boxes created in Excel 2007 are blank in Excel 2003? | Charts and Charting in Excel | |||
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same | Excel Discussion (Misc queries) | |||
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat | Excel Discussion (Misc queries) |