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. |
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. |
All times are GMT +1. The time now is 04:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com