Spreadsheet Analysis
The
Spreadsheet Analysis tool provides useful information on a
spreadsheet, helping you to answer questions such as:
• Which are the **most important or largest worksheets?**
• **How are the worksheets related to each other?**
How does the logic flow within the spreadsheet?
• Are there many blank rows being stored, increasing
file size unnecessarily?
It produces the following statistics for each worksheet:
• The **number of unique formulae in the worksheet**
(a formula copied from the cell above or to the left is not
counted again).
• The **number of unique formulae in the worksheet
referring to every other worksheet**.
• The number of rows and columns in use and the number
actually stored in the spreadsheet. |