When exporting reports to Excel from the ribbon (or via a macro), only the DynaRanges on the first sheet of the report will be activated / calculated. When using Batch XLSX Snapshot, however, all DynaRanges on all sheets will be calculated.
Macro function activeworkbook->export() only calculates DynaRanges of the first sheet (like XLSX Snapshot when triggered by button/menu).
Most users are not aware of this limitation and expect a "complete" export of their report.
Using Batch XLSX Snapshot is not always an option, e.g. due to custom variables a customer can set whilst using the report or due to very restricted user environments where the complete application runs only in a standalone mode with no access to navigation bar.
