View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SimonCC SimonCC is offline
external usenet poster
 
Posts: 79
Default Links won't update unless files are actually opened

If the calculation under Tools | Options is already set to automatic, try
going to Edit | Links and make sure Update is selected as Automatic. Also
check the Startup Prompt there to make sure it's not selected as Don't
display the altert and don't update automatic links.

-Simon


"BretJacobs" wrote:

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?