| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Office 2003 excel file in Office Excel 2007
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening Office 2003 excel file in Office Excel 2007
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Joel" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I import an Office 2007 file into Office 2003? | Excel Discussion (Misc queries) | |||
| Opening an Office 2003 Excel doc with Office 2000 NT | Excel Discussion (Misc queries) | |||
| Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
| Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
| MS Office 2003 file opening problems | Excel Discussion (Misc queries) | |||
Linear Mode
