Wait with calculation of other sheet references after edit a cell?
 

Hi,

I have sheets were I would like to wait with updating likend cells until you
leave the worksheet. I have bought FastExcel and have reduce the number of
calculations with IF, OFFSET, INDIRECT formulas, using named formulas and
"helpcells" etc (and still improves these), but still I would like to try
some recalculation intelligence.

I still want to make recalculation ON the activesheet, but not updating
formulas on OTHER sheets that is linked to the activesheet. When I leave the
activesheet, I want to update the other pages concerned by reference links
with activesheet.

When I can have a little userform telling to wait, cell recalulation in
progress etc. Any suggestions how a routine could look like? I want to be
sure the cells you see always is calculated and ready ...

I need it to work for versions Excel XP and later.

/Kind regards