Thanks Charles, I went through many of your pages, but I didn't find anything
that would explain what I see.

The weird thing is that if I press the Delete button on any cell:
- press once, wait one second, press once again - all my functions are
executed once
- press twice, very quickly - the volatile functions are executed once, the
other functions are executed twice
- press twice, quickly, but not as before - some of the non volatile
functions are executed once, others twice.

I wasn't able to reproduce the problem with a smaller model.
I tried creating some slow functions, either volatile or not, and they make
Excel non responsive, that is the calculation always runs once, and through
the end.

In the real case intead, it looks like the calculations starts in
background, the interface is responsive, and:
- If it has time to finish it runs only once;
- If it has no time to finish (because i press a key) it interrupts and
restarts.

Does it make sense?

Thanks,
Stefano

"Charles Williams" wrote:



I can't think of any event triggered by the change of a formula in a just
created workbook that would fire the calculation of another workbook.


Excel does not calculate at workbook level: it calculates all open workbooks
not just the active workbook.
So if you have 2 workbooks open and trigger a recalculation in one of them
the other workbook will also be recalculated, even if there are no
references from the other workbook to the first workbook.

see http://www.decisionmodels.com/calcsecretsg.htm


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com


.