Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Previously Posted...Need Help!
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Previously Posted...Need Help!
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 -- theDud ----------------------------------------------------------------------- theDude's Profile: http://www.excelforum.com/member.php...fo&userid=1655 View this thread: http://www.excelforum.com/showthread.php?threadid=31402 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question not posted? | New Users to Excel | |||
Why my posting are not posted! | Excel Discussion (Misc queries) | |||
Hi ..I posted some more info ..... | Excel Discussion (Misc queries) | |||
Posted Code | Excel Programming | |||
Re-posted need more detail | Excel Programming |