LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Metallo
 
Posts: n/a
Default Update Links - Problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
Automatic Chart Update? Mike Fox Charts and Charting in Excel 7 January 6th 05 01:29 AM
File asks to update when no links were created Dave Links and Linking in Excel 1 December 16th 04 08:10 PM
Problem with date base units for x axis Peter Carr Charts and Charting in Excel 1 December 15th 04 09:11 AM
upgrade to excel 2003 update broken links error tigger Links and Linking in Excel 0 December 1st 04 06:39 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"