keep manual recalculation mode on

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

hi,

when I send a file saved with Automatic calc on, the users claim it causes
Excel to recalculate when they open it. This way it causes a dispruption in
the large models they have open at the time in the manual mode.

I always thought that if Excel is in manual, any new file will open in
manual. Can you please shed some light?

Thanks
 
Excel's calculation is set by the first file it opens (which MAY be
personal.xls). Opening another file will not change it. That file could have
a workbook_open event which turns calc to manual, but only after it's been
calculated (!) if it's currently automatic.
 
I would use VBA --
go to Toos/macro/Visual Basic

in the left column of objects, double-click on 'This Workbook'
in the blank space copy the following:

Private Sub Workbook_Open()
With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
end

if you want to set it back to automactic when the workbook is closed, also
copy into 'This Workbook':

Private Sub Workbook_BeforeClose(Cancel As Boolean)

With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
end
 
Back
Top