I guess to clarify, I am not tempted to hit cancel on Jet when opening a workbook, rather was trying to avoid Jet having to calculate all together if it was not necessary. The particular report I am working on now has +Values on all sheets but the Options sheet. I tend to save in Report mode unless developing then may save in design. What will be the difference if I open a report that was saved in design as compared to Report mode as far as Jet calculating window?
Date
Votes
6 comments
-
Jet Reports Historic Posts Hello,
When I open an excel workbook that is a Jet report it will often bring up the window like it is refreshing data (locking me from using the file until complete). I am pretty sure Jet does not refresh reports when you open a file. Is this simply Jet loading? The time for this window to complete and go away is directly affected by the size of the file/report. Some larger reports can take several minutes or more before the file becomes available. It is rather obnoxious to be honest.
Usually I need to open the file and then refresh it after making some changes to the Jet logic. If this opening Jet window is not doing anything vital can I turn it off or terminate it so I can get into the workbook and start working before I am ready to refresh the report?
Much appreciated! -
Jet Reports Historic Posts Are your report sheets locked? Does Cell A1 have 'Auto+Hide+Values' in it?
The knowledge base has an article on this: http://kb.jetreports.com/article/AA-00505/0/:
"…in a workbook with locked sheets, Jet saves all formulas to a hidden worksheet and does not recalculate them when the workbook opens…" -
Jet Reports Historic Posts Different reports vary on whether they are Locked/Values or neither for me. I follow the logic in the link you shared, but I am not logically connecting that with the Jet bar executing when I open a workbook. Are you saying based on whether I put Locked/Values or just leave the default Auto+Hide that Jet will have to perform operations when I open a workbook? If that is true my next question is which is most efficient way to build a report for speed of refreshing. For most of my reports it doesn't matter if they are locked/Values or neither. We work in a group where we most of us are Designers so protecting the end user is not a priority in this particular case. Fast running reports is the most important thing for this task.
It would be nice to minimize (remove) the Jet window when I open a file if I can avoid it. Also, Refresh time is most important to me. Quicker the better. Do you have a recommendation on this as well? -
Jet Reports Historic Posts Having Auto+Hide, Auto+Hide+Values or Auto+Hide+Lock does not have any affect on the speed of a report running.
Adding the +Values or +Lock is necessary for non-Designers to view a report, however, by adding the +Values or +Lock, it should minimize the refreshing issue you are encountering upon opening a report. -
Jet Reports Historic Posts That is helpful to know that adding Values/Lock or the lack there of does not affect run time.
However, I am still curious what Jet is doing when it starts "calculating?" If it is not refreshing the report with new data then what is it doing? The large the report the longer it calculates which tells me it isn't starting Jet. It is calculating something…Formula validation or error checking? That was my original question… -
Jet Reports Historic Posts To answer some of your original questions, if Jet is doing some calculations, cancel them at your own risk. Doing so could cause some corruption. While it isn't refreshing the report, it may be performing other calculations within the report itself.
Cancelling midway through can sometimes cause those functions/formulas to have other affects on the report.
Without seeing a report, it is hard to know what it going on but it seems that you note that it isn't for every report. I'm curious, are you saving these in Design mode or Report mode? As previously mentioned, it is wise to add the +Values or +Lock to cell A1.
Please sign in to leave a comment.