0

Prevent Report Running when Opening file?

Jet Reports Historic Posts

April 23, 2008 16:07

None

Follow

How can I prevent a report from "reporting" when I open the excel file? I thought I could force the report to not re-generate upon opening.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts April 23, 2008 16:51

  If you are using Excel 2003 or later, you can change cell A1 to Auto+Hide+Values on all worksheets in the workbook.
  
  Also, for some reports, I've had to go to, in Excel 2003 (not sure where it is in 2007), Tools, Options, and on the Calculation tab, set the calculation to Manual.
  
  Also, I think if you use =NOW() or =TODAY(), Excel always recalculates the workbook, even when set to Manual.

• 0
  
  Jet Reports Historic Posts April 23, 2008 19:48

  May I recommend to read the Jet Reports Help file here. You may download this from the support site.
  
  http://support.jetreports.com/index.php?_m=downloads&_a=view&parentcategoryid=14&pcid=0&nav=0
  
  Please read the chapters on "Introducing Report viewers" and "Evaluating formulas" :)