Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation: Automatic except tables
What is the use of calculation for Automatic except tables .
You can view this Tools - Options - Calculation tab. Thanks Vinod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation: Automatic except tables
"tables" In this context means tables as in the DataTables menu.
Recalculating such tables can be very time consuming, because it effectively means recalculating your workbook many times (the actual number of times depends on the size and number of dimensions of the table). In the development stage you might want to recalculate automatically to test the calculation model for one set of data. Then you could use this option. After development is finished, you could switch to full automatic calculation. Of course there are other ways to achieve the same result, but this happens to be an option Excel provides which is quite handy. -- Kind regards, Niek Otten Microsoft MVP - Excel "Vinod" wrote in message ... | What is the use of calculation for Automatic except tables . | | You can view this Tools - Options - Calculation tab. | | Thanks | Vinod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic calculation | Excel Worksheet Functions | |||
Automatic re-calculation | Excel Discussion (Misc queries) | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
automatic calculation | Setting up and Configuration of Excel |