Worksheet change event not working on linked cells

[Mac10]

My cells are linked to another sheet and I would like to run a macro when they change in value.

I tried the macros listed below but neither of them work.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[davesexcel]

The WorkSheet_Change event will not work if it is a formula that is changing.
Check out the calculation event