Here's the scenario ....

I have a worksheet cell that calls a user-defined function. The
user-defined function, in turn, relies on inputs from other spreadsheet cells
that are part of an iterative calculation procedure. Since the user-defined
function is not really needed for every iteration step (ie. doesn't change
that much), and since it's fairly computational intensive, I'd like to have
the ability to turn off manual calculation only for that particular cell
which calls the function. After my iterative calculation procedure has
converged, I would then like to update the function value, and re-run the
iterative procedure.

Jim

"Niek Otten" wrote:

Hi Jim,

Not exactly.
But do visit:

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

Or, tell us what you're trying to achieve

--
Kind regards,

Niek Otten

"Jim Hagan" wrote in message
...
Hi all,

Is there a way within Excel to set the calculation mode for a single cell
to
manual, while keeping the rest of the workbook on Automatic calculation
mode.

Thanks for any help provided,

Jim