View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
pete_sa pete_sa is offline
external usenet poster
 
Posts: 2
Default Manual Update of Links in Excel 2003

Hi

Odd problem here - the option to Manually update Links is greyed
out/disabled. Thus, by default, it always automatically updates the links.

This is causing a bit of a problem for the accountant: if she makes even a
small change to a linked cell, Excel will automatically update all the links
and thus take a long time before she can carry on working with the
spreadsheet.

I've tested this myself (set up a basic spreadsheet linked to another one) -
and when I view the links, the Update Manually option is also greyed out.

Anyone have any ideas as to why the manual option is greyed out?

Thanks,

Pete