I have a troubling issue with simultaneous execution of external link
update and workbook_open macro.
The Excel workbook has a range of cells (a table of 85 rows and 2
columns) whose cells contain formulas that link to a remote server t
download stocks data.
The workbook_open macro executes code that depends on content of thes
cells in order to setup range names and some other calculations.
The problem is that full update of external links takes a few seconds
which is too log and causes the workbook_open macro to crash upo
opening because not all cells have updated yet.
What is needed is a way to force the macro to wait until all externa
links are updated (but without tying up computer processor time whic
would slow external data updating time and speed).

Any help?
thank you.

Alseikha

--
Alseikha
-----------------------------------------------------------------------
Alseikhan's Profile: http://www.excelforum.com/member.php...fo&userid=3236
View this thread: http://www.excelforum.com/showthread.php?threadid=53241