Excel Tables

[dwolter]

Is there a way to turn off table calculations once calculated (besides the
tool - options-calculation - automatic except tables).

Does hiding a sheet with the tables prevent excel from calculating the table?

 

[Eduardo]

Hi,
Hidding the tables will not prevent excell from calculating it

 

[Gord Dibben]

You could copy and paste special as values.

Hiding sheet does not prevent calculation.


Gord Dibben MS Excel MVP