Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel 2003 Opens Excel 97 Files & recalcs links

Opening up XL 97 files in XL 2003 displays the message asking if you
want to update links with the buttons of "Update Links" and "Do Not
Update Links". Pressing "Do Not Update Links" results in the links
being updated anyway and if the linked file is not available you will
get errors in the cells with the link and any cell referencing these
cells.

Is there any way to convert an XL 97 file to XL 2003 and preserve the
data regardless of the linked files access? The Microsoft web site
describes this problem and a manual process to correct at
http://support.microsoft.com/kb/327006/.

A conversion program would save our company much in lost productivity
not to mention the headaches involved in manually correcting all the
files we have with embeded links.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 Opens Excel 97 Files & recalcs links

I'm not sure if this will help--since it means that the registry for each person
would need to be changed...

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl



RobertD wrote:

Opening up XL 97 files in XL 2003 displays the message asking if you
want to update links with the buttons of "Update Links" and "Do Not
Update Links". Pressing "Do Not Update Links" results in the links
being updated anyway and if the linked file is not available you will
get errors in the cells with the link and any cell referencing these
cells.

Is there any way to convert an XL 97 file to XL 2003 and preserve the
data regardless of the linked files access? The Microsoft web site
describes this problem and a manual process to correct at
http://support.microsoft.com/kb/327006/.

A conversion program would save our company much in lost productivity
not to mention the headaches involved in manually correcting all the
files we have with embeded links.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel 2003 Opens Excel 97 Files & recalcs links

Dave,

I tried this, even though I am using XL 2003 and it worked with
modification. Instead of Excel/9.0 I had to use Excel/11.0.

For those who are ready to update the registry, using RegEdit, the
entry is:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

create a new REG_DWORD value named: FullCalcOnLoadOldFile

it will default to the value of 0 which is ok.

Remember to backup the registry before making this change.

Thanks for the help.

Dave Peterson wrote:
I'm not sure if this will help--since it means that the registry for each person
would need to be changed...

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl



RobertD wrote:

Opening up XL 97 files in XL 2003 displays the message asking if you
want to update links with the buttons of "Update Links" and "Do Not
Update Links". Pressing "Do Not Update Links" results in the links
being updated anyway and if the linked file is not available you will
get errors in the cells with the link and any cell referencing these
cells.

Is there any way to convert an XL 97 file to XL 2003 and preserve the
data regardless of the linked files access? The Microsoft web site
describes this problem and a manual process to correct at
http://support.microsoft.com/kb/327006/.

A conversion program would save our company much in lost productivity
not to mention the headaches involved in manually correcting all the
files we have with embeded links.


--

Dave Peterson


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Excel 2003 Opens Excel 97 Files & recalcs links

Dave,

I tried this, even though I am using XL 2003 and it worked with
modification. Instead of Excel/9.0 I had to use Excel/11.0.

For those who are ready to update the registry, using RegEdit, the
entry is:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

create a new REG_DWORD value named: FullCalcOnLoadOldFile

it will default to the value of 0 which is ok.

Remember to backup the registry before making this change.

Thanks for the help.

Dave Peterson wrote:
I'm not sure if this will help--since it means that the registry for each person
would need to be changed...

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl



RobertD wrote:

Opening up XL 97 files in XL 2003 displays the message asking if you
want to update links with the buttons of "Update Links" and "Do Not
Update Links". Pressing "Do Not Update Links" results in the links
being updated anyway and if the linked file is not available you will
get errors in the cells with the link and any cell referencing these
cells.

Is there any way to convert an XL 97 file to XL 2003 and preserve the
data regardless of the linked files access? The Microsoft web site
describes this problem and a manual process to correct at
http://support.microsoft.com/kb/327006/.

A conversion program would save our company much in lost productivity
not to mention the headaches involved in manually correcting all the
files we have with embeded links.


--

Dave Peterson


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 Opens Excel 97 Files & recalcs links

Good points--both the version and the tip to back up the registry!

RobertD wrote:

Dave,

I tried this, even though I am using XL 2003 and it worked with
modification. Instead of Excel/9.0 I had to use Excel/11.0.

For those who are ready to update the registry, using RegEdit, the
entry is:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

create a new REG_DWORD value named: FullCalcOnLoadOldFile

it will default to the value of 0 which is ok.

Remember to backup the registry before making this change.

Thanks for the help.

Dave Peterson wrote:
I'm not sure if this will help--since it means that the registry for each person
would need to be changed...

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl



RobertD wrote:

Opening up XL 97 files in XL 2003 displays the message asking if you
want to update links with the buttons of "Update Links" and "Do Not
Update Links". Pressing "Do Not Update Links" results in the links
being updated anyway and if the linked file is not available you will
get errors in the cells with the link and any cell referencing these
cells.

Is there any way to convert an XL 97 file to XL 2003 and preserve the
data regardless of the linked files access? The Microsoft web site
describes this problem and a manual process to correct at
http://support.microsoft.com/kb/327006/.

A conversion program would save our company much in lost productivity
not to mention the headaches involved in manually correcting all the
files we have with embeded links.


--

Dave Peterson


--

Dave Peterson
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
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2003: Temporarily "turning off" links to external files... Birmangirl Excel Discussion (Misc queries) 1 August 19th 05 02:51 PM
Excel 2003 Add-in: Access Links Spiderman Steve Excel Discussion (Misc queries) 0 June 22nd 05 03:36 PM
Quattro Pro files in Excel 2003 convert quattro Excel Discussion (Misc queries) 0 February 2nd 05 12:19 PM
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 1st 05 11:31 PM


All times are GMT +1. The time now is 08:40 AM.

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

About Us

"It's about Microsoft Excel"