You can indeed calculate Sheets (SHIFT+F9) and ranges (VBA needed).

Lots of information about Excel's calculation mechanisms here on Charles
William's site:

www. decisionmodels.com

--
Kind regards,

Niek Otten

"pm" wrote in message ...
hello,

is there any possibility of limiting 'calculate' (F9) to particular cell,
range,
sheets, worksbooks?
i have about 70 excel files (weight ca 300 MB). Automatic calculation is
off.
manual last about 1 minute (with 512 MB RAM), what in effect last about
several
houres when i calculate files in loop of two variables
limiting (restricting?) calculate instruction to cells, range, sheets
would
accelerate all process

PS. how can i disable macro in sheet's code when another macro is running?
and enable it after ...
eventually, how disable macro when F9 is pressed?

regards