Office 2007 excel error message one or more invalid names found


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.
 
Ad

Advertisements

S

Shane Devenshire

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

Top