Product Ideas
Share your suggestions and ideas. Vote on ideas you find valuable.
Share your suggestions and ideas. Vote on ideas you find valuable.
Do you want to play a crucial role in shaping Jet Global products?
When a workbook is taking too long to calculate one often tries to Cancel the calculation. Unfortunately, the cancellation often takes longer than letting the original calculation continue. This should not be so. Cancel should mean Cancel. Upon receiving that command, Jet should abandon all its work and immediately restore the original model from its hidden tabs.
I’m not sure what Jet is doing for so long when it is slow in canceling. Presumably, it is trying to recreate the hidden tabs that store the cached data. In such cases, Jet should just abandon the recreation effort and delete the sheets. If users have to Refresh a workbook rather than being able to use cached data the next time they run it, I believe that would be ok and they would accept it. The reason they’ve tried to Cancel is that something wasn’t right in the first place. You could make it an option on Application Settings called “Fast Cancel” if you felt that not all users would want to do it.
Guest
If you go from Run time view to Design View in Jet, you see a little dialog about restoring formulas etc. It usually displays for a few seconds. Presumably, this is what is going on in the background when you cancel a report.
It seems like Jet could just create a temporary copy of the Jet Report sheet before it starts processing the report. If the report completes successfully, Jet could just delete the temporary copy. If the user clicks Cancel, then just copy the temporary copy created earlier back on top of the Jet Report.
Agreed it is very painful to have to cancel a large report.
+100 for this improvement.
When clicking on Cancel the refresh process time must stop immediatly in a fraction of a second.
Same issue sometimes when clicking on Design, Jet tries to evaluate the formulas, when all we want to see is all the formulas in design mode immediately.
Would be great to see an updated on this request, it's been a major pain point with Jet for years.
I agree completely. This is a terrible pain, and means that I end up showing users how to crash out of Excel using the task manager, which means they are more likely to lose data (especially if they have other reports open at the same time)