Product Ideas

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

Conditionally running sheets

We have reports with multiple sheets and in some cases it is not necessary to calculate/run all report sheets. Currently It is possible to hide sheets dynamically but in order to improve also the performance it would helpful to prevent dynamically running report function for a whole sheet. We need this for the Excel add-in and the Web Portal.

  • Michael Schuchart
  • Nov 7 2018
  • Under Consideration
  • Attach files
  • David Lyons commented
    30 Jan, 2019 03:55pm

    From a troubleshooting perspective it would be nice to ignore all Jet functions within a given sheet. This would allow one to run a single sheet at a time to better isolate issues and would save time processing unnecessary sheets. We could implement via a new keyword, maybe +IgnoreSheet,+NoCalculateSheet, etc... 

  • Michael Schuchart commented
    22 Nov, 2018 08:21am

    Amendment:

    In this context if a complete sheet is not calculated the sheet should be automatically hided!