Office 2007 excel error message one or more invalid names found

  • Thread starter Thread starter Duncan
  • Start date Start date
D

Duncan

I have encountered problems opening spreadsheets from an earlier version of
excel. I receive an error message "one or more invalid names" and then all
numbers in the spreadsheet go to !Ref.
 
Hi,

all numbers in the spreadsheet or all formulas in the spreadsheet?

A range name like XX1 which would have been OK in 2003 is invalid in 2007
because that is now a valid range within a spreadsheet. If this is the
problem Excel generally trys to deal with it but if it can't you may need to
do so yourself. Any range names beyond IV65536 will be illegal in 2007, for
example A100000, or XF10.
 

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

Turning off "invalid ref" messages 2
Excel 2007 - Invalid Names 1
Error message 1
Error message 1
Opening Office 2003 excel file in Office Excel 2007 1
invalid names were detected in this workbook 2
Ref Edit problems with Excel 2003 SP3 2
What causes an "Invalid Format" error in Excel 2002 to crash the f 1

Back
Top