Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 09, 02:53 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,101
Default 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   Report Post  
Old July 3rd 09, 05:56 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I import an Office 2007 file into Office 2003? jeiacono Excel Discussion (Misc queries) 2 June 5th 08 03:15 AM
Opening an Office 2003 Excel doc with Office 2000 NT Roxy Excel Discussion (Misc queries) 4 February 8th 08 10:54 PM
Office 2007 compatibility pack on Office 2003 (slow network file fox_mulder33 Setting up and Configuration of Excel 0 January 2nd 08 03:28 PM
Opening an Office 2007 Excel file in Office 2003 charstachura Excel Discussion (Misc queries) 1 November 8th 07 09:36 PM
MS Office 2003 file opening problems noblep Excel Discussion (Misc queries) 1 March 19th 05 06:21 PM


All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017