> I know how to update links manually yet when I go onto
> Edit, Links, the Manual option is greyed out - only the
> Automatic option is available. How can I access the
> Manual check box?
All Excel formula links are always "automatic".
The manual option is only available for other types of links (e.g.
links to non-Excel files or to other applications).
What were you trying to achieve?
If you are using Excel 2002 or later you can specify startup behaviour
from the Edit / Links dialog, if that helps.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup