John,
This should help:
http://www.decisionmodels.com/calcsecretsh.htm

NickHK

"John" wrote in message
...
How does calculation = semiautomatic work? Can I use this setting to
speed
up calculation of certian parts of very large sheets?