Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have the following situation: 1 Folder that contains 10 WBs + 1 WB for consolidation The folder is located under \\home share\FolderName\... Now, so far no problem at all, every week, I can update the consolidation WB according to the changes in the 10WBs. Since last week, my company asked me to put the folder under: \\home share\Data folder\FolderName\... I did so and of course, had to try changing the source link according to the new path. Well, when I try to do so Edit\Links|ChangeSource, I browse to the new path and click OK, but a message pops up saying that the file cannot be found, I click OK and the folder where the file actually is appears, I click cancel, it re-appears, and so on for around ten times, then the link changes. This is certainly very strange. But, when I get to update the third link (to WB 3) it says that the path name is too long. The old location path name was \\home share\FolderName\... 34 characters The new is 39 The new "DATA" folder under which I have to put my folder is a company one which is automatically syncronized every day and therefore it allows me to set the folder as "make it available off line" and have it on my PC when not in the office. Any idea why I cannot get the links to change? Thank you Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Automatic Chart Update? | Charts and Charting in Excel | |||
File asks to update when no links were created | Links and Linking in Excel | |||
Problem with date base units for x axis | Charts and Charting in Excel | |||
upgrade to excel 2003 update broken links error | Links and Linking in Excel |