You could copy and paste special as values.

Hiding sheet does not prevent calculation.


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 05:02:02 -0700, dwolter
wrote:

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?