I'm not sure how this will work for UDFs. It works with simple links, though.

Dave Peterson wrote:

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 those errors.

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

Maybe it'll work for you.

probbins914 wrote:

Hi Ada,

So I'm not exactly sure why this file opens fine in prior versions of Excel
and not Excel 2003 ? Is is because there are links to other worksheets that
these links need to be updated thus causing the failure to open? To me it
seems, the workaround is to use a prior version.

Thanks For Your Help
Paul Robbins

"Ada Pan [MSFT]" wrote in message
...
Hi Paul,

I have received your email with the attachment.

When I open the file, the following message will prompt:

This workbook contains links to other data sources.
* If you update the links, Excel attempts to retrieve the latest data.
* If you don't update, Excel uses the previous information.

In the meantime, I also find some formulas are used in this workbook. For
example:
='C:\Documents and Settings\<USERNAME\Application Data\Microsoft\
Excel\XLSTART\PERSONL.XLS'!ZeroKurve.ZeroKurve(B$2 ,E11,C$4:C$24)

Obviously, you have external data source linked to this workbook.

Based on my experience and research, this issue may cause if the linked
file is NOT existed in the proper location on your computer, or if the
workbook that you want to open has links to a closed workbook that is
saved
in the HTML file format.

To resolve it, please perform the following steps:

1. Place these linked file in the proper locations on your computer and
then check if this issue reoccurs.

If the linked files are placed in the proper locations and the problem
persists, please go to next step:

2. To work around this issue, open the HTML file that the workbook is
linked to before you try to open the workbook that contains the links.


If you work around this issue by performing the second step, based on my
research, it is because Excel cannot update links from a workbook that is
saved in HTML file format if that workbook is closed. Excel updates the
links correctly only if the link source file is already opened. For more
information, please refer to the following article in Microsoft Knowledge
Base:

813977 Error Message: This Workbook Contains One or More Links That Cannot
Be
http://support.microsoft.com/?id=813977

If there is anything unclear, please feel free to let me know.

Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no
rights.


--

Dave Peterson

--

Dave Peterson