Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference External Worksheets & Protect Worksheet / Workbook | Excel Worksheet Functions | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
copy worksheet to another workbook | Excel Discussion (Misc queries) | |||
How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) |