Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Cancel means Cancel

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.

  • Michael Kaptein
  • Mar 31 2018
  • Under Consideration
  • Attach files
  • Gabriele Hayden commented
    31 Jan 22:00

    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)