How to stop a column to autoupdate?

[tazz]

Hi,

I have a col. that takes data from 6 different tables.

When I update a cell in a table the column will automatic update.

Is there a way to stop this automatic update until I give permission?

Each update takes 30-45 sec (for updating one cell in a table) and to update a row in a table it takes me appx. 2 min.

Thank you.

 

[Montrey]

Go to options and turn off automatic calculate.

 

[chicky36]

Hi Tazz,


As Montrey suggested, go to Formula - Calculation options - manual.


This will stop automatic calculation in your workbook. And whenever you want that column and that tab to update records simply use Shift + F9 and it will calculate.


Note: whenever you want to update any record you will have to use Shift +f9 otherwise your records will not update so be careful.


Thanks

Chicky