Difference between revisions of "Clear all data values"
(Created page with "New in Version 7.5 - it is possible to clear all the data values from a workbook. Go to XLCubed -> Extras -> Clear all data values. This does the following: ## Clears all gr...") |
|||
| Line 1: | Line 1: | ||
New in [[Version 7.5]] - it is possible to clear all the data values from a workbook. Go to XLCubed -> Extras -> Clear all data values. This does the following: | New in [[Version 7.5]] - it is possible to clear all the data values from a workbook. Go to XLCubed -> Extras -> Clear all data values. This does the following: | ||
| − | + | # Clears all grids | |
| − | + | # Sets any XLCubed Formulae to "Working.." | |
The workbook can then be saved or published. For a saved workbook the numbers will only be re-retrieved once the workbook is loaded and the grids & formulae are refreshed. For a published report, the published file will not contain any data and the numbers will only be retrieved after the report is viewed in Web Edition | The workbook can then be saved or published. For a saved workbook the numbers will only be re-retrieved once the workbook is loaded and the grids & formulae are refreshed. For a published report, the published file will not contain any data and the numbers will only be retrieved after the report is viewed in Web Edition | ||
Revision as of 16:35, 27 June 2013
New in Version 7.5 - it is possible to clear all the data values from a workbook. Go to XLCubed -> Extras -> Clear all data values. This does the following:
- Clears all grids
- Sets any XLCubed Formulae to "Working.."
The workbook can then be saved or published. For a saved workbook the numbers will only be re-retrieved once the workbook is loaded and the grids & formulae are refreshed. For a published report, the published file will not contain any data and the numbers will only be retrieved after the report is viewed in Web Edition
