Unopened usually means the file is no open in excel. Such a file would not
update at all, so I assume that is not what you mean.

It sounds like you either have two workbooks or two worksheets in the same
workbook. In any case, I am not aware of the case where the activeworksheet
will not update links - unless you are working in the sheet pretty heavily,
cut I am not aware that that would be a prevention. In fact, it seems to
me, being in the foreground would be more responsive.

I assume you are getting stock quotes or something using a DDE link.

--
Regards,
Tom Ogilvy

nb wrote in message
...


Thanks Tom. The reason for having two sheets is that I can't get an open
active worksheet to update external information into it. Therefore the
workaround is to have an unopened background sheet that uploads the
external information that is passed to it and a second linked one that
is open and available to the user. Is this the only way to do this or is
there a way to get an active open sheet to refresh itself and display
external information that is passed to it? Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!