Strange because when doing the update manually we don't generally see
any messages (XL97). However, Application.DisplayAlerts = False (make
sure you set back to True afterwards) should do what you want.
Regards
BrianB
==============================================
Quote:
> I am programming a spreadsheet and cannot get excel to update the
> links without prompting me to open the "source" worksheet. I know
> that there is a way to update links without opening up the source
> worksheet. Anyone know what i am doing wrong? Thank you in advance.
> Nick Florez
External Cell Links