Resetting Data and Restoring Formulas
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.