RTD methods in excel called before workbook_open event
 

If an excel file which includes RTD formulas is opened, then the RTD
components [written in C#] constructor and connect_data methods are
called before workbook_open event which occurs in Excel. My impression
was that the workbook_open event gets fired before the RTD methods are
called. This is a problem for me as I have about 100 RTD formulas
spread across different worksheets in the Excel workbook.

I was hoping to intercept the workbook_open event and disable
calculations on the inactive worksheets and only allow the active
worksheets to calculate. However, I am unable to do that just because
the RTD Component constructor and Connect_Data methods are being
called before the workbook_open event. I am using .Net 2.0 and Office
2003.

Is there any solution to my problem? Please let me know. Thanks in
advance.