Can I calculate just one worksheet in a multi-worksheet workbook?
 

Can I calculate just one worksheet in a multi-worksheet Excel workbook? If
so, how?

Can I calculate just one worksheet in a multi-worksheet workbook?
 

I supose you would have to goto tools ,calculations and set it to manual


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518045

Can I calculate just one worksheet in a multi-worksheet workbook?
 

sorry read the questoin wrong


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518045

Can I calculate just one worksheet in a multi-worksheet workbook?
 

In short - I believe not, certainly within general excel.

But why would you want to do that anyway?

Within a macro you can calculate a selected region only, which is useful in
a big workbook if you're updating some lookups before converting to numbers
then as soon as you switch back to auto calc the rest of the worklbook will
catch up.

The other permanent option is that as soon as you've finished with a sheet
and want to lock the numbers just copy/pastevalues over itself.

Giz

"Captive Thinker" wrote:

Can I calculate just one worksheet in a multi-worksheet Excel workbook? If
so, how?