keep manual recalculation mode on
 

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

--
______
Regards,
Greg

keep manual recalculation mode on
 

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.

"Greg" wrote in message
...
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

--
______
Regards,
Greg

keep manual recalculation mode on
 

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
--
hope to help,
cm


"Greg" wrote:

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

--
______
Regards,
Greg