I have an application running in a manufacturing environment that has DDE
links to an I/O server. There are over 100 links on one sheet and ten links
on another page. I have not experienced any problems with link updating
regardless of whether the sheet with the links is the active sheet or a
different sheet is the active sheet. If you could pass along more about the
links or the source of the external information we could help more.


"Tom Ogilvy" wrote in message
...
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!