You've not really given enough data to allow anyone to give much help.

How big is the range?

Have you been able to step through the code?

Normally you can return an immediate value of "#updating" or whatever, then
go get the data and then notify excel that the RTD is done by calling
UpdateNotify on the IRTDUpdateEven class instance.

Are you trying to force synchronicity out of an asynchronous architecture by
consequence of design????

I suggest you have a look at the MSDN for examples of how to do this in a
manner more conformant with best practice.

Good luck.



--
www.alignment-systems.com


" wrote:

I have created a RTD server in .NET which gets information from a
database via a web service. While the cells are updating like when I
copy a range it seems to take a while for the whole group to update.
While that is happeing I cannot do anything with Excel. I would like:

1) to put a place holder in the cell indicating it is being updated
(example: #updating) so the users would know what's going on and be
able to work in other parts of the sheet but which would seem like an
error to dependant cells so they don't make calls to the web service.

2) rtd to call back the cell and replace the #updating value with the
real value when it changes.

Does anybody know how to do either of these things?