Excel Workbook Instance

I have this problem. I use excel 2007. I have two workbooks. Fist workbook contains a macro that got data link of "from web" that continuously downloads stock market ticker data. Second work book contains my stock portfolio and i cross reference second workbook with first one for stock prices.

I could not access second workbook when first workbook macro was running as both the workbooks were under single instance. I found a way to open two workbooks in different instances, i.e. two instances. This solved my problem and now i can access second workbook and work on that when first workbook's macro is running. However it created one more problem. Now both workbooks act too independently and cross references in second workbook stopped working.

Please help me to solve either of these two problems.

1. Single instance: I should be able to access second workbook when macro in first workbook is running

2. Multiple Instances: Incase if above problem can't be solved then I am compelled to have two instances. In such case I should be able to cross reference second workbook with first one.

Thanks in advance for your help. Kindly excuse me for writing a long description but due to nature of this problem this is inevitable

Hi, see if using DoEvents prior to execution of the import data helps when using one instance of Excel.

regards,
Graham

Thanks Parrynz for your response. I will try that and see if that works. have a good day

Hello Parryz,

I tried "Doevents" but no use. Second workbook doesnt respond when first workbook's macro is running.

Any alternative solution?

Thanks advance for your help