This worksheet will be present only if the active workbook contains worksheet formulas.
The following table explains the items that appear on the "Worksheet Formulas" worksheet. All information relates to the active workbook at the time Summarizer was run.
|
Item
|
Details
|
| Workbook Name
|
Name of active workbook
|
| Worksheet Name
|
Name of worksheet from which formulas have been extracted
|
| Formulas Listed
|
Number of formulas listed on report (relative to total number of formulas on "Worksheet Name"). A maximum of 65,531 formulas will be listed per worksheet.
|
| Cell
|
Address of cell containing formula
|
| Cell Value
|
Result returned when formula is evaluated
|
| Formula
|
Worksheet formula (If the worksheet is protected and the formula is hidden, it will not be possible to display the formula and Hidden (protected sheet) will be displayed instead.)
|
Double Click Feature
If you double click in Column A on a cell address then you will be taken to the cell from which the corresponding formula was extracted. To return to the cell that you double clicked, click the Go Back button located on the UltraSleuth toolbar.
This feature is only available if the worksheet from which the formula was extracted is open and visible.
