Here is a major problem i am facing. I have an Excel file which has data
with quite a few formulas. But after i have done all the work, *save*
the file, close the file and try to open again, it won't let me do
anything cos it is calculating all the cells. Even if i ad a colum, it
does not allow me to do anything cos it is calculating the cells. Is
there anyway i can rectify this problem? Please help.

Thanks,
Thomas.


--
Tomac
------------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...o&userid=31555
View this thread: http://www.excelforum.com/showthread...hreadid=515784

Hi

Turn off automatic calculation - Tools on the menu, Options, Calculation and
click on the Manual option. You just then have to remember to recalc when
you have input new data.


--
Sharon


"Tomac" wrote:


Here is a major problem i am facing. I have an Excel file which has data
with quite a few formulas. But after i have done all the work, *save*
the file, close the file and try to open again, it won't let me do
anything cos it is calculating all the cells. Even if i ad a colum, it
does not allow me to do anything cos it is calculating the cells. Is
there anyway i can rectify this problem? Please help.

Thanks,
Thomas.


--
Tomac
------------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...o&userid=31555
View this thread: http://www.excelforum.com/showthread...hreadid=515784

I had a simialr problem with a spreadsheet I created. I put the following
code in "ThisWorkbook" for my spreadsheet. It allowed me to choose whether I
wanted to turn off automatic calculation when I opened the spreadsheet. I am
sure someone can improve upon my code as I am still fairly new at this.

Private Sub Workbook_Open()
MsgBox ("This spreadsheet can take a while to update every time you change a
cell used in the calculation (30 seconds or so). After clicking 'OK' you will
be asked whether you want to turn off automatic calculation or not.")
answer = MsgBox("Do you want to turn automatic calculation off?", 4)
If answer = 6 Then
With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
MsgBox ("You have choose to turn off automatic calculation. To update
the cells press F9 or to turn it back on go to ToolsOptions and then the
'Calculation' tab and select automatic calculation on.")
Else
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End If
End Sub

"Tomac" wrote:


Here is a major problem i am facing. I have an Excel file which has data
with quite a few formulas. But after i have done all the work, *save*
the file, close the file and try to open again, it won't let me do
anything cos it is calculating all the cells. Even if i ad a colum, it
does not allow me to do anything cos it is calculating the cells. Is
there anyway i can rectify this problem? Please help.

Thanks,
Thomas.


--
Tomac
------------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...o&userid=31555
View this thread: http://www.excelforum.com/showthread...hreadid=515784