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