0

Stopping "Calculation in Progress"

Jet Reports Historic Posts

August 04, 2009 21:43

None

Follow

I know i have seen this topic before but never saw a fix for it. in some of my reports that are for a single month i have a date cell set up to enter the beginning month date and the ending month date. the formula cells point to them so all i do is enter dates and run. My problem is that when i open the file i have to hit cancel "calculation in progress" and when i enter the date for each date cell it starts running again and i have to repeat the cancel prompt each time. Is there a way to halt calculating until i enter my dates?

• Facebook
• Twitter
• LinkedIn

9 comments

• 0
  
  Jet Reports Historic Posts August 05, 2009 02:58

  If you change the calculation to Manual,
  XL2003: Tools–>Options–>Calculation
  XL2007: Formuals Tab–> Calculation Options
  and save the report.
  
  when the report is next opened it wont refresh/recalculate the formulae.
  
  -Bromy

• 0
  
  Jet Reports Historic Posts August 05, 2009 03:41

  if your report is in report mode when opened, then you should use +values in cell A1.
  
  That will hide Jet formulas behind the values during the report mode. so next time when you open the report, Excel will not re-calculate.
  
  however if your report is in Design mode, then what i normally do is either wait for a few seconds or simply press Ctrl+F3 to open the Task manager and close the Jet progress.exe.
  
  by switching the automatic to manual calculation might not be the best way in my opinion. ;)

• 0
  
  Jet Reports Historic Posts August 13, 2009 04:07

  Closing the JetProgress.exe wont always work.
  because the Jet Report is basically a macro the uses the Command Application.ScreenUpdating=FALSEwhich means your screen will be forever in a "Frozen" state.
  
  you could do that however and run a macro of your own to fix it.
  a basic macro to fix it would be something like
  Sub UpdateScreen() Application.ScreenUpdating=TRUE End Sub
  -Bromy

• 0
  
  Jet Reports Historic Posts August 14, 2009 17:24

  david, the best option to stop calculation in progress is to do as LegacySubaru said and put Auto+Hide+Values in cell A1 and save the workbook in report mode. Turning on Manual calculation mode can lead to some other problems and we don't recommend it.

• 0
  
  Jet Reports Historic Posts March 09, 2015 18:38

  I have tried this. It works once, but then starts to recalculate again. If I save the report after I run it - it does not recalculate when I open it. If I then send it to someone else and they open it - it recalculates again. ??

• 0
  
  Jet Reports Historic Posts March 09, 2015 20:55

  If the workbook has +VALUES then it shouldn't re-calculate when opened. It is possible you may have a corrupted workbook. If saving the report in Report mode with +VALUES doesn't work then I would recommend you submit a ticket to the Support site and have the Jet gurus take a look to see if there is anything wrong.
  
  Jason

• 0
  
  Jet Reports Historic Posts March 11, 2015 08:10

  Just a note to mention that saving the "template report" in report mode can cause problems if you use the scheduler, as the parameters on the options tab don't update.

• 0
  
  Jet Reports Historic Posts March 11, 2015 13:24

  Just a note to mention that saving the "template report" in report mode can cause problems if you use the scheduler, as the parameters on the options tab don't update.

  
  Is this true if using a batch file, or just setting the parameters directly in the scheduler?
• 0
  
  Jet Reports Historic Posts March 11, 2015 13:31

  I had that problem with a batch file. Trying to work out why all my expenses reports were running, but with the same data rather than individual lines, took ages!