ExcelBanter - Excel Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Tables (https://www.excelbanter.com/excel-worksheet-functions/234140-excel-tables.html)

dwolter

Excel Tables

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

Excel Tables

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

"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?

Gord Dibben

Excel Tables

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?

All times are GMT +1. The time now is 09:23 PM.