excel 2007 problem

H

hung

I have an excel 2003 file and I can not open it. When I open this file, there
is a message that:
"one or more invalid names were detected in this workbook. Those invalid
names have been changed to #REF!"
can you help me to solve this problem?
 
D

Dave Peterson

Aren't you prompted to provide a new name for those invalid names?

Just type in a new name to see if that fixes the problem. Remember if you have
VBA code that used the original name, it'll have to be fixed there, too.

If this doesn't help, I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
to help me find those broken names/formulas.

Then if they were important enough to fix, I'd go back to xl2003 and open that
workbook and change the names to something valid.
 

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

Opening Office 2003 excel file in Office Excel 2007 1
Excel freezing after sharing document by Email 0
Working outlook via vba code with xlsx - error 0
Embedded Excel into Word with Tables 0
one or more invalid names were detected in this work sheet 2
Problem with SET & REF function 0
Error message 1
Excel keeps asking me if I want to save an already saved file. 0

Top