#1   Report Post  
Old August 17th 05, 09:03 AM
Posts: n/a
Default Updating links

I need to move Excel files to another PC. Some of the files have references
to Excel workbooks. The number of linked workbooks for each file varies from
30 to 120.
When I open such a file it tries to refresh the links, but in vain. The only
way is to change path for each reference workbook, although all the reference
workbooks are in the same folder.
Is it possible to change the folder reference for all the workbooks at once
(not one by one)?
Thank you in advance for any tips!

  #2   Report Post  
Old August 17th 05, 01:04 PM
Bill Manville
Posts: n/a

My linkmanager will do this (and more) for you.
Send an email to Bill_Manville @ compuserve . com (without the spaces)
to request a free copy.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

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
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM
Updating Links Doug Excel Worksheet Functions 0 February 16th 05 05:21 PM
links not updating although autocalc is On? Hoochi Coochi Man Excel Discussion (Misc queries) 3 January 14th 05 12:04 AM
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM
Updating Automatic links doesn't work with arrays Mats Samson Excel Discussion (Misc queries) 0 December 18th 04 03:17 PM

All times are GMT +1. The time now is 10:36 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017