Clear additional ranges

Alchemex 7.1

Home > Report Manager > Working with Reports > Run a Report > Clear Additional Ranges

Clear Additional Ranges

When a Microsoft Excel workbook is linked back to a report (via Create and Link function), Sage Intelligence Reporting clears out the data for all the Raw Data Sheets (for a standard report this is always the first sheet, for Union Reports it is the sheets specified for each Union Child report.

 

If there are any other ranges that you would like cleared whenever the Create and Link function is used then you can name these ranges in this property and the ranges will be cleared each time the book is linked.