If you have Excel 2002 or 2003 the Edit, Links, Startup Prompt command gives
you greater control over how links update. Otherwise I don't think there is
an answer.

--
Jim
"blatham" wrote in
message ...
|
| I have a spreadsheet with links to another workbook that take a long
| time to update if the external workbook is closed. To prevent this I
| have written a macro that fires on the open event of the workbook that
| automatically opens the links. However the message box asking whether
| the user wants to update links or not still appears (even though I
| suppress alerts in the on open macro) so there is still the opportunity
| for a user to click 'Update' and be waiting ages.
|
| Is there a way to suppress this message does anyone know as it appears
| to occur before the on open macro fires.
|
| Regards
|
| Ben
|
|
| --
| blatham
| ------------------------------------------------------------------------
| blatham's Profile:
http://www.excelforum.com/member.php...o&userid=19441
| View this thread: http://www.excelforum.com/showthread...hreadid=534488
|