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


In your linked work book, have you tried

Edit Links Update Values



"BretJacobs" wrote in message
Having a tough time working with a linked file. I created a summary
that links to multiple unique separate worksheets. Links will not
(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?