Excel 2007 Pivot Table references no longer work



I have several Excel 2003 version spreadsheets with pivot tables that use the
GETPIVOTDATA function to extract data from a pivot table in one worksheet
into another worksheet. In 2003 the file reference had the file extension of
".xls". When I convert and save all of these to the 2007 format ".xlsx", none
of these cross-worksheet references work anymore, because the file extension
has changed.

Is there no other way to fix this than to do a mass find and replace on
".xls" to ".xlsx"??. Even if I do this what happens when I save these all
back as 2003 version. Do I have to change all these back to ".xls" again? Am
I missing something obvious here?

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