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?