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
  • Michael Schuchart commented
    November 22, 2018 08:21

    Amendment:

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

  • David Lyons commented
    January 30, 2019 15:55

    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...