Clear additional ranges

Alchemex

Home > Report Manager > Working with Reports > Run a Report > Clear additional ranges

Clear Additional Ranges

When an Excel book is linked back to a report (via Create and Link function), Sage Accpac Intelligence 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.