How to down-convert a pivot table from 2007 to 2003?

M

mythodox

I had created a number of pivot tables and pivot charts in Excel 2007.
Unfortunately my company does not yet "support" 2007, so in order to
make the spreadsheet available so others can open it, I saved it as a
2003 Excel format. But the 2007 pivot tables do not convert into 2003
pivot tables, they just hard-code themselves so that you can't manage
them anymore. You can only look at the specific filter / view that was
saved when you open them with 2003.

Is there a way to down-convert pivot tables so that they "remain"
functional when you open them in 2003? It would sure save me from
having to start all over again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
How to base a pivot table on another pivot table? 3
Excel 2007 Pivot table error "There are too many records to complete this operation" 3
transfer pivot table to new workbook data 10
Pivot Table Data Source 2007 v. 2003 1
Excel 2007 - Create Pivot table from another pivot table 6
Excel How do I create a pivot table in excel 2003? 3
Pivot tables downgrade 2007->2003 3

Top