Standard cell content linking not updating itself...?

[IndigoDragon]

Hi there,

I have a datasheet (Excel) that is filled with selected data from a different sheet. The data is linked with the standard cell content 'link' like: =data!D1 (or =data!$D$1).
Should work, did work, but somehow the link got broken and the cells only update when I edit the formula's in the cell and hit enter; not anymore when data in the "data" sheet changes.

What could be the cause of this and is there code to force the sheet to update? (".Activate" doesn't do the trick.)

TnX & Grtz!!!

 

[PHV]

You may consider the Calculate method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IndigoDragon]

Hi PHV,

Ofcourse!
Thanx!