How to stop calculation on open?



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


.



Relevant Pages

  • Re: Continuous Form code for current record
    ... I'd also be interested in seeing a calculation that slows down your form's ... opening to such an extent! ... And before someone chimes in, as they always do, yes, storing ...
    (microsoft.public.access.formscoding)
  • Re: Summary task durations are NOT responding to subtasks
    ... Check Tools, Options, Calculation: Calculation is probably set to Manual. ... Microsoft Project MVP ... sub tasks. ... Opening the file on another machine works fine. ...
    (microsoft.public.project)