Formula Viewer and Spreadsheet Detective

Formulas in spreadsheets are the source of most errors.  Long formulas can also be difficult to comprehend.  So the ability to be able to find, analyse and break them down into understandable sections, to see how they are used and to be able to detect errors is critical.

We provide two tools to help Excel users create more reliable spreadsheet:

• Formula viewer: An add-in to ComplyXL that allows you to explore the formulas in your spreadsheet.  Formula Viewer is part of the Desktop, Professional and Enterprise editions of ComplyXL
• Spreadsheet Detective: Detect potential spreadsheet calculation errors and document workbooks

Contact us

For a trial license for the Formula Viewer and Spreadsheet Detective click here or contact us on (US) 1-800-401-0289 or (EU) +44 027 043 2777. If you are looking for specific functionality not shown here, please call for more information.

Formula viewer

Benefits include:

• Complex formulas broken down to help reduce the likelihood of errors
• Help you understand the complex formulas created by other users
• Display formulas in a structured way showing each part of the formula or function
• Display is updated dynamically as you explore cell formulas and drill into the formulas of dependent cells
• History list shows the path of your review so you can jump back at any point

See our short presentation about the Formula Viewer or learn more...

Spreadsheet Detective

Benefits include:

• Audit Excel formulas to confirm your spreadsheets calculate the way you expect them to and to find potential errors
• Create formula reports to document the structure of your spreadsheets for later review
• Annotate existing spreadsheets to identify formulas and highlight potential errors
• Generate a sensitivity report to show how cells contrubute to the totals in your workbooks

Find out more about the Spreadsheet Detective