Hi Pete,

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

Probably because the source and target worksheets are open.

Cheers

--
macropod
[MVP - Microsoft Word]


"pete_sa" wrote in message
...
| 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
|
|