Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Luigi
 
Posts: n/a
Default linked cells to workbooks in different folders

I have 3 separate folders, folder(a) contains a workbook that has worksheets
linked to other workbooks in the same folder, folder(b) contains a workbook
that has worksheets linked to other workbooks in the same folder, folder(c)
contains a workbook that has worksheets linked to workbooks in each (a) and
(b) folders.
When I copy all the folders to another network path folder only the worbooks
in folder (a) and (b) have there paths changed automatically but the workbook
in folder (c) still shows the original workbook path locations. I need to
individually change the path via the "Edit/links/change source" function and
in some cases I get the error message "path or formula to long".

Does anyone know why the path doesn't change automatically?
Reply
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
How to count how many cells a linked cell group occupies Kanaski79 Excel Worksheet Functions 7 September 23rd 05 08:49 PM
Updating linked workbooks Michael Rekas Excel Discussion (Misc queries) 1 August 15th 05 01:42 PM
Show cells have been read - linked ufo_pilot Excel Discussion (Misc queries) 0 August 5th 05 04:22 PM
Preserving data integrity in linked workbooks KG Excel Discussion (Misc queries) 1 February 18th 05 12:45 AM
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM


All times are GMT +1. The time now is 04:11 PM.

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"