Yes. To force it you can link a cell to one of the updating cells, this will
trigger Calculate.It is a trick I use a lot with Excel 97 where Data
Validation changes do not trigger the change event.

Bob

"CraigB" wrote in message
...
Bob,

Doesn't that function only work after a recalculation? If so, doesn't it
still come down to recognising when the cell has changed value (in order
to
recalculate to start the calculate event)?

Thanks,
Craig.

"Bob Phillips" wrote:

This often doesn't trigger the change event.

You could try the calculate event.

--
HTH

Bob Phillips

"CraigB" wrote in message
...
I'm trying to use the worksheet change function to start a macro. I'm
monitoring a cell which is linked to an external source. When that
cell
changes, it should start the macro, but nothing happens.

If I start the macro by manually changing the cell myself then the the
macro
works properly, but I want it to start automatically when the linked
cell
changes. Any ideas.

Thanks in advance,
Craig.