#1   Report Post  
Old March 2nd 06, 08:07 PM posted to microsoft.public.excel.misc
dave glynn
 
Posts: n/a
Default updating links

I have a series of files that represent data for each week of the year. These
are linked to other files that are common to each week.

Unthinkingly I provided for all files to be updated automatically on opening.

Unfortunately if I open (say) last wek's saved files they will automatically
update to this weeks values.

Universal update in tools/options/edit is switched off but obviously
overwritten by the files that specify otherwise.

Is there any way to override the updating before I open all of 52 weeks
files and get this week's resulys for all of them?

Help!!!!!


Thanks as always


Dave Glynn

  #2   Report Post  
Old March 2nd 06, 08:28 PM posted to microsoft.public.excel.misc
dave glynn
 
Posts: n/a
Default updating links

Sorry everyone was being crass solution was onvious

Thanks all the same


Dave

"dave glynn" wrote:

I have a series of files that represent data for each week of the year. These
are linked to other files that are common to each week.

Unthinkingly I provided for all files to be updated automatically on opening.

Unfortunately if I open (say) last wek's saved files they will automatically
update to this weeks values.

Universal update in tools/options/edit is switched off but obviously
overwritten by the files that specify otherwise.

Is there any way to override the updating before I open all of 52 weeks
files and get this week's resulys for all of them?

Help!!!!!


Thanks as always


Dave Glynn



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
Excel 2003 links are not updating between workbooks Tami C Excel Worksheet Functions 3 October 11th 05 02:03 AM
External Links not updating Lou Di Pietro Excel Discussion (Misc queries) 0 September 15th 05 09:48 AM
?? Links Not Updating ?? djm023 Excel Discussion (Misc queries) 3 September 7th 05 02:10 PM
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM
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 05:54 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