Please enable JavaScript to view this site.

Altova Work in Process XBRL add-in for Excel, version 2020r2

Creating a new WIP Report

Resetting Data and Restoring Formulas

Scroll Home Prev Top Next More

In some cases, you might want to clear all entered data from the WIP report sheet in one operation. For example, you might want to do that when you discover that validation fails after you have pasted some data from an external source.

 

The Reset WIP Report Data command is available in the WIP tab and it performs the following actions:

 

Clears all data from the sheet

Restores the Excel formulas to their default state

Restores the WIP report properties to their default state.

 

Note:The Reset WIP Report Data command does not affect the cell formatting.

 

To reset the WIP report data, click Reset WIP Report Data > Reset WIP Report data in the Excel ribbon. A confirmation dialog box prompts you for confirmation before data is actually cleared.

 

Restoring only formulas

You can also restore the Excel formulas to their default state, without clearing the existing data. This is necessary, for example, after you imported data from an XBRL report instance. To restore only formulas, click Reset WIP Report Data > Restore only formulas in the Excel ribbon.

wip_restore_formulas

© 2020 Altova GmbH