#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 471
Default Update Links Slow

My supervisor just showed me a monthly process I am to inherit. Basically it
involves these steps:
1. Copy Last month's files to This month's folder.
2. Rename the files.
3. Update the links to point to the new-name files instead of the files in
last month's folder with last month's name.

She says that to do this, it is faster if you copy everything to the local
hard drive, update the links to refer to local files. Refresh the links.
Then upload back to the network and change the links to refer to network
files and then refresh the links again. She said that is faster than just
doing everything on the network.

(And don't get me started about changing the entire process!--not an option
right now!)

It would seem there would be an easier way to do this. Ideas?
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
Links slow in 2007 Russell Excel Discussion (Misc queries) 0 December 21st 09 10:57 AM
Slow opening links between workbooks with links created in 2003 Russell Excel Discussion (Misc queries) 0 December 14th 09 02:59 PM
DDE links slow opening in Vista? sonicscooter Excel Discussion (Misc queries) 0 December 15th 08 10:13 PM
Update links box gives Continue or Edit Links dialog KarenF Excel Discussion (Misc queries) 0 May 18th 07 01:17 PM
Slow grouping and ungrouping since update Bruce H Excel Discussion (Misc queries) 0 June 1st 05 03:37 PM


All times are GMT +1. The time now is 02:37 AM.

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

About Us

"It's about Microsoft Excel"