View Single Post
  #1   Report Post  
Old August 2nd 06, 11:16 PM posted to microsoft.public.excel.misc
BretJacobs BretJacobs is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 4
Default Links won't update unless files are actually opened

Having a tough time working with a linked file. I created a summary report
that links to multiple unique separate worksheets. Links will not update
(even if all varieties of F9 are tried [shift, ctrl, etc]) unless the
individual files are open also. All files are stored on my laptop's hard
drive, and are not mapped to any network drive.

I know that is NOT the way the links are supposed to work, as I have used
links many many times before. However, is there some trick to Office 2003
that I am missing?