Sometimes when we open our Jetreport excel files, it will automatically rerun the report. At times, it will rerun when we just want to sort the columns. Once rerun, it will takes over 20 hours to complete. If we cancel, all data will be lost, showing only #value. Is there a way to block Jetreport from auto-rerun of reports? This is really frustrating.
Date
Votes
1 comment
-
Jet Reports Historic Posts Add Auto+Hide+Values to cell A1 on any sheet in your report and then run the report (by clicking Jet -> Report). Now you will notice that all the Jet formulas have been changed to values, so Excel will not recalculate the Jet formulas. This is called Report Mode and if you save the workbook in Report Mode, it will not recalculate the Jet formulas when you open it or change it. To change the Jet formulas, just click Jet -> Design to go back to design mode and make changes.
Regards,
Hughes
Please sign in to leave a comment.