Ablity to just recalc one worksheet
Not that I'm aware of (someone else may later make me aware of one) -
consider that if there are any off-sheet dependencies, they may need to be
recalculated to make the results on your one sheet accurate.
If constant recalculating is causing a real slowdown, you could turn
automatic calculation off and then manually recalculate when only when you
feel the need.
To set calculation to Manual:
Tools | Options | [Calculation] tab - choose Manual
to calculate manually while the workbook is in use: [F9]
"Cameron" wrote:
is there a way to setup a macro to just recalc one worksheet rather then the
entire project?
|