SOS!!! Excel 2007 - Pivot tables created in 2003 format

T

Tina

I am an early adapter at my company. All my customers are on Office XP/2003.

I have a bunch of large (> 100 MB) Excel workbooks with pivot tables which
were created on Office 2003. These tables have several thousand rows each.

I need to save the pivot table in refreshable mode in these workbooks. The
files open in Compatibility Mode, but when I save and re-open the pivot table
is just a list and not a pivot table.

I also tried roundtripping, but that did not work either. I saved the file
as 2007 macro-enabled and then re-saved in 97-2003 format.

I need this very urgently, do I have any choices except to go back to 2003?

Thanks much
 

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

SOS!!! Excel 2007 Pitvot Tables Created in Old Format 2
Refreshing 2003 Pivot Table w/ Excel 2007 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Tables 2003 v 2007 0
Pivot tables deactivate 0
Pivot Tables in 2007 don't work in 2003 0
pivot table report not valid when opening xls created in 2007 0
Pivot tabel field name not valid in 2007, was in 2003 0

Top