Hi,

This is caused by that the Excel Application is STA which handle the com
automation command based on message queue.
When we enter the editor mode of the formula, the focus will be changed to
the fomular bar window and it will run a message loop to handle the
message. In the meanwhile the com call incoming will pend because the
fomular bar message loop will not handle the com call message, till the
fomular bar lost focus and the excel main window will get the focus and run
the message loop to handle the com call, if in a predefined time period,
the focus did not change back to the excel main window, the error dialog
will pop up the vb client did not get response from excel com server in a
predefined time out value.

So I think we would better not call the automation code when we have
entered the certain editor mode, e.g. the fomular bar, the cell editor mode
and so on.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.