View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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