| 1.
|
General |
| 1.1 |
UltraSleuth overview
|
| 1.2 |
Menu and toolbar description
|
| 1.3 |
UltraSleuth Options dialog box
|
| 1.4 |
System requirements
|
| 1.5 |
UltraSleuth Gold license
|
| 1.6 |
Contacting Digital Solutions
|
| 1.7 |
How to Enter the UltraSleuth Gold Serial Number
|
| 1.8 |
How to Buy UltraSleuth Gold
|
|
|
| 2.
|
UltraSleuth AdvancedSearch |
| 2.1 |
Search Excel names, formulas, comments, cell values with AdvancedSearch
|
| 2.2 |
How to use UltraSleuth AdvancedSearch
|
| 2.3 |
Description of the AdvancedSearch dialog box
|
| 2.4 |
How to run a Simple Search with AdvancedSearch
|
| 2.5 |
Regular expression syntax in AdvancedSearch
|
| 2.6 |
Understanding the AdvancedSearch reports
|
| 2.7 |
Configuring a spreadsheet search in AdvancedSearch
- Configuring case sensitive, wildcards, complete cells and regular expression Excel searches in the Options settings in AdvancedSearch
- Searching in Excel cell values, formulas, comments and names using the Look In setting in AdvancedSearch
- Search active worksheet, search active workbook or search all open workbooks using the Scope setting in AdvancedSearch
|
| 3. |
UltraSleuth CopyFinder |
| 3.1 |
Check for spreadsheet errors in Excel formulas copied across rows and columns with CopyFinder
|
| 3.2 |
How to use CopyFinder
|
| 3.3 |
Description of the CopyFinder dialog box |
| 3.4 |
Understanding the CopyFinder's results |
|
|
| 4. |
UltraSleuth InputFinder |
| 4.1 |
Find the input cells for any cell with InputFinder
|
| 4.2 |
How to find cell inputs using InputFinder?
|
| 4.3 |
Description of the InputFinder dialog box |
| 4.4
|
Setting the scope of InputFinder's trace
|
| 4.5
|
Understanding the InputFinder's report
|
|
|
| 5. |
UltraSleuth Summarizer |
| 5.1 |
Document worksheet comments, external links, VBA procedures, defined names, sheet configuration, worksheet formulas with Summarizer
|
| 5.2 |
How to document a spreadsheet using Summarizer
|
| 5.3 |
Understanding Summarizer's results
- "Workbook" worksheeet report
- "Comments" worksheet report
- "External Links" worksheet report
- "Names" worksheet report
- "Procedures" worksheet report
- "Sheets" worksheet report
- "Worksheet Formulas" worksheet report
|
| 6. |
UltraSleuth ProtectionRemover |
| 6.1 |
Unprotect Excel workbook and worksheets with UltraSleuth ProtectionRemover
|
| 6.2 |
How to remove spreadsheet protection with ProtectionRemover
|
|
|
| 7. |
WorkSheet Compare |
| 7.1 |
Compare Excel Spreadsheets with UltraSleuth WorksheetCompare
|
| 7.2 |
How to Compare Spreadsheets with WorksheetCompare
|
| 7.3 |
Selecting the Excel Worksheets or Workbooks to Compare
|
| 7.4 |
Identity, Database, and Auto Comparison Methods in Worksheet Compare
|
| 7.5 |
Refining Spreadsheet Comparison in WorkSheet Compare with Rules
|
| 7.6 |
Selecting the Type of Excel Comparison Report in Worksheet Compare
|
| 7.7 |
Understanding the Worksheet Compare Results
|
| 7.8 |
Added or Deleted Excel Rows or Columns in the Worksheet Compare Report
|
| 7.9 |
Common Excel Rows and Columns in the Worksheet Compare Report
|
| 7.10 |
Changed Spreadsheet Cells in the Worksheet Compare Report
|
| 7.11 |
Copy of Selected Excel Worksheets in the Worksheet Compare Report
|
|
|
| 8. |
Troubleshooting UltraSleuth |
| 8.1 |
How do I install UltraSleuth?
|
| 8.2 |
How do I uninstall UltraSleuth?
|
| 8.3 |
How do I load UltraSleuth?
|
| 8.4 |
How do I unload UltraSleuth?
|
| 8.5 |
How do I close UltraSleuth?
|
| 8.6 |
UltraSleuth is installed but I can't see the toolbar
|
| 8.7 |
Excel won't open multiple copies of UltraSleuth
|
| 8.8 |
UltraSleuth does not open automatically when I start Excel
|
| 8.9 |
Excel automatically opens the wrong version of UltraSleuth. How do I fix this problem?
|
| 8.10 |
How do I undo the coloring inserted by CopyFinder or InputFinder?
|
| 8.11 |
The double-click feature in UltraSleuth does not work
|
| 8.12 |
The UltraSleuth double-click feature jumps to the wrong location
|
| 8.13 |
Excel behaves strangely when I click on a hyperlink
|
| 8.14 |
Summarizer does not detect VBA code in the active workbook
|
|
|
| 9. |
Glossary of Excel terms
|
