Spreadsheet Data

The Spreadsheet Data Lists are lists of the data held on the worksheet or sheets contained in the active workbook. For access to these functions see the Spreadsheet Data Lists Menu and the Audit Tools Shortcuts.

There are 5 list types

Data Type Description
Numbers Lists cells containing numbers (but not dates) and the associated formula.
Formulae Lists cells containing formulae and the associated result
Shapes Lists shapes, their location on the worksheet and any associated macros
Errors Lists cells containing errors and the formula that generated the error
Text Lists cells containing text and the associated formula if generated by one.


The lists are standardised such that they are ready for immediate investigation using the List Analysis and Comparison tools.

The data lists provide the raw data for a variety of analyses and purposes. these include

This is not an exhaustive list of the purposes to which the Spreadsheet Data Lists can be put, but it gives a flavour of the range of analyses that they can provide the basis for.


Remarks

You may want to retain a Spreadsheet Data List as a record of the state of play of the worksheet and/or workbook at a particular date and time. The List Management dialog allows spreadsheet designers to secrete copies of the data lists within the workbooks such that normal users do not see or have access to them.

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.


See also

User Tools


  Last Updated: 03/09/2009 | © ACBA (UK) LTD, 2009