keep manual recalculation mode on

[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

 

[Bob Umlas]

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.

 

[cm]

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