Excel 2007 - Reference is not valid

C

carryt

We are in the process of switching over to Office 2007 from Office
2003 in our office. Right now only a handful of people have made the
change.

There is a spreadsheet that was created in Excel 2003. It's quite a
complicated spreadsheet with pivot tables and several worksheets. This
file opens fine in Excel 2003, updates the pivot tables and works
great. However, when opening it in Excel 2007 the error "Reference is
not valid." pops up. No other error, and the pivot table does not
work.

I have tried selecting all of the add-ins and also enabling macros and
nothing seems to help. I have also done a "save as" and tried to save
it in all of the possible formats and still the same thing happens.

Anything else I should try? Has anyone else encountered this?
 
G

Guest

We're experiencing similar issues where pivot tables created in 2003 become
static tables when opened in 2007. Unable to find resolution to this issue.
 

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

Reference is not valid for Pivot tables 2
Excel 2003 Pivot Table in Excel 2007 3
Pivot Table "Data source reference is not valid" error cause? 1
macros in Excel 2007 1
Changing Database links? 3
excel 2007 pivot table: how to paste special formats? 1
dynamic data range in pivot tables excel 2007 1
2007 to 2003 Formating issues 1

Top