Re: How to stop calculation on open?

Excel picks up that calculation for that session from the first workbook opened.

If you try to use any of that workbook's events, then you'll be too late.

You can change the calculation manually, then open your workbook--or use a
"dummy" workbook that changes calculation mode, then opens your real workbook.

Kind of like:

Option Explicit
Sub auto_open()
application.Calculation =xlCalculationManual
Workbooks.Open Filename:="c:\my documents\excel\book1.xls"
ThisWorkbook.Close savechanges:=False
End Sub



G Lykos wrote:

Greetings! Have an unwieldy workbook. It is set for manual calculation, no
calculation on save. I'd like to inhibit calculation when opening it as
well, but have been unable to intercept it using the various workbook and
application events. Any suggestions on how to do so?

Thanks,
George

--

Dave Peterson
.

Relevant Pages

  • Re: Prevent automatic calculation for workbook being opened
    ... It's stored with each workbook. ... But the application only changes when it opens ... So if they open a workbook that's been saved in manual calculation mode first, ... I have a database which makes reports export to excel files and just ...
    (microsoft.public.excel.programming)
  • Re: Prevent automatic calculation for workbook being opened
    ... How can I do that without workbook has been opened? ... Then it could turn the calculation mode to ... I have a database which makes reports export to excel files and just ... You could do it manually or you could have another workbook that opens, ...
    (microsoft.public.excel.programming)
  • Re: Prevent automatic calculation for workbook being opened
    ... You have to have an open workbook to change calculation mode--if there isn't one ... How can I do that without workbook has been opened? ... I have a database which makes reports export to excel files and just ... You could do it manually or you could have another workbook that opens, ...
    (microsoft.public.excel.programming)
  • RE: pulling data from multiple workbooks
    ... Dim MyPath As String, FilesInPath As String ... Dim Fnum As Long ... Dim mybook As Workbook, BaseWks As Worksheet ... 'Change ScreenUpdating, Calculation and EnableEvents ...
    (microsoft.public.excel.misc)
  • Re: Prevent automatic calculation for workbook being opened
    ... So if they open a workbook that's been saved in manual calculation mode first, ... When the addin opens, the ...
    (microsoft.public.excel.programming)
Loading