If you can answer this you'll be a hero in our office!

[dibbhead]

In our office we have recently moved over to office 2007. We have client reports with pivot tables that we send out.

However, our clients typically have office 2003. They are unable to open an office 2007 file. If we save the file as office 2003 then we lose the pivot functionality. It is vital that our clients are able to manipulate these pivot tables.

Can anyone think of any way round this?

You'd think our IT team would have some answers...

 

[VoG]

Ask your clients to install the compatibility pack http://www.microsoft.com/downloads/...70-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

 

[shyrath]

i found this by google.

source: http://www.brighthub.com/computing/windows-platform/articles/24484.aspx


Enabling [Compatibility Mode] How-To

The trick is to get the phrase, [Compatibility Mode], to appear at the top of your Excel window next to your spreadsheet's title. Without this mode enabled, your PivotTables will not work in 97-2003 documents, and you will receive nagging messages whenever you attempt to save a file. Example .
Open Excel to a new, blank Workbook .
Click on the "Office Icon" menu , go to "Save As", and select "Excel 97-2003 Workbook" from the side menu that appears.
Then. using the dialog box that appears, create your filename and select where it will be saved, click "Save".
Next, go back to the "Office Icon" menu, and click on "Close".
Once again, go back to the "Office Icon" Menu, and click "Open".
Finally, using the dialog box that appears, navigate to where you saved the newly-created workbook, and click "Open".
If done correctly, you should now see [Compatibility Mode] appear next to name of your workbook at the top of the screen.
You can now proceed to create your PivotTable, as normal, and will not be prompted about your PivotTable not being compatible with previous versions of Excel (97-2003) whenever you save.

 

[dibbhead]

Really appreciate your replies.

We'll try the microsoft download for the client in the first instance.

Shyrath - the problem is with existing reports, we don't really want to have to recreate but it's good to know for any new client reports where we know they don't have 2007!

Thanks again.