Previously Posted...Need Help!

[Guest]

I'm not sure if I posted this in the correct discussion group...please let me
know if I should post elsewhere. I believe the root cause of the problem
below may be in the VBA code associated with my destination workbook..but not
sure. Your help would be greatly appreciated!

Previous Post:

Problem With Links
I have created a worksheet within a workbook with links to another worksheet
in another workbook. When I open the destination workbook on my computer
(Windows XP, Excel 2003), it finds the source workbook and loads the
requested information. When I distribute the destination workbook and the
source workbook to others (some with Windows XP, some with Windows 2000, some
with Excel 2003, some with Excel 97), along with instructions for placing it
and the source workbook in a specified directory strucxture identical to that
which is on my computer, the destination workbook begins to open and displays
the following message in a dialog box: "This workbook contains one or more
links which cannot be updated." The dialog box goes on to explain the
results of selecting either of two options; Continue or Edit Links.

No amount of effort to "Update Links," "Change Source File Location," etc.
seems to allow the destination workbook to open without displaying this
message. I've ensured that all related selections in the Tools:Options menu
are checked/unchecked appropriately (Calculation tab, Security tab - Macro
Security, General tab, etc.).

Another intriguing bit of information. If I place the two workbooks in a
self-extracting ZIP file that when executed, places the two workbooks in the
same directory structure as defined in the links used, and then run the file
on my computer, the resulting destination workbook opens on my computer
displaying the same message: "This workbook contains one or more links which
cannot be updated."

Any ideas?

 

[theDude]

Without knowing what specified directory structure you requested you
users to save the files in, it's hard to tell what the problem is. I
Microsoft Windows (2000 is what I am currently using), if you log in a
a specific user, then your default Desktop directory is located in
directrory specific to the logged in user like this:

'C:\Documents and Settings\-username- \Desktop'

The file directories are specific to the username (My Documents, etc.
that is logged in to the computer. Since each username is different
the link won't work because the filepath that was embedded in the lin
from the computer that you logged into changes from user to user.

If you save the SOURCE file to the root directory 'C:\Temp' _before
you create the link(s) in the destination file, it should be able t
update the link(s) if the user saves the SOURCE file to the roo
'C:\Temp' directory prior to opening the destination file