Big Help

  • Thread starter Thread starter Tomac
  • Start date Start date
T

Tomac

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.
 
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.
 
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 >Tools>Options 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
 
Back
Top