Calculation: Automatic except tables

[Vinod]

What is the use of calculation for Automatic except tables .

You can view this Tools -> Options -> Calculation tab.

Thanks
Vinod

 

[Niek Otten]

"tables" In this context means tables as in the Data>Tables 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

| What is the use of calculation for Automatic except tables .
|
| You can view this Tools -> Options -> Calculation tab.
|
| Thanks
| Vinod