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.

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,

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,

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

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