Opening Office 2003 excel file in Office Excel 2007

J

Joel

Please help me to rectify the problem. I have a file created in Excel 2003
and when I open the file in Excel 2007 it prompt for an error message " One
or more invalid names were detected in this workbook. Those invalid names
have been changed to #REF " when the file open the chart did not display
properly. The file was open in compatibility mode.
 
S

Shane Devenshire

Hi,

because there are only 256 columns and 65,356 rows in Excel 2003 the
following range names are legal
IW3
A100000
ZZ200000

None of these are legal in 2007 because there are 16,384 columns and
1,048576 rows. If Excel can it will convert them to things like
IW3_

You should find and modify all range names and then see if things clear up.
 

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

Excel freezing after sharing document by Email 0
Excel opening 1
Embedded Excel into Word with Tables 0
Shortcuts in OneDrive 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
excel 2007 problem 1
names were detected in this workbook 2
invalid names were detected in this workbook 2

Top