Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Thanked 0 Times in 0 Posts

    workbook formulas processed before open event (excel 2000/r2)

    I have a Excel workbook where I load xla's in the Thisworkbook object of the template. I have noticed that if the workbook has formulas then a "pre-calculation" is processed before the workbook open event. Is there someway to not have this occur?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post

    Re: workbook formulas processed before open event (excel 2000/r2)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Jim

    Could you open <font color=red>"Another"</font color=red> workbook that would turn calculations to manual, (<font color=blue> Application.Calculation = xlManual </font color=blue>) then open your template, your add-Ins and the last add-In closes the <font color=red>"First"</font color=red> workbook and set calculations to Automatic, or what ever you care it to be from that point on?

    Seems like a lot of work, and I am searching for an example of what event fires when, and in what sequence, but I am sure that the Workbook.Open is one of the <font color=red>"VERY Early"</font color=red> ones.

    I hope this helps.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts