Home > Excel Business Solutions > Excel Productivity > Navigation and Auditing > Formula Analyzer Share

Formula Analyzer

Excel formula analyzer for navigation and auditing


Excel Formula Analyzer

(Recommended)
Rate this solution:
(4.3/5 from 3 votes)
Formula Analyzer screenshot
Formula Analyzer for Excel (Spreadsheet Auditor) is an Excel add-in which enables to view formulas in a different, more user friendly manner. Formula Analyzer for Excel shows all origin links and/or dependence links which may exist between formulas of a selected range.

Formula Analyzer for Excel has a unique tool which can analyze, within a specific range, a group of formulas and all the precedence/dependence connections between them. The additional Link Manager tool allows to perform a variety of operations with the external and internal links within a workbook.

The Cell Reference Tracker, is a versatile Formula Analyzer for Excel tool allowing to navigate between the cells which originate and/or depend on a cell under observation. This works even through sheets contained in other workbooks.

The Decompose Formula tool can determine the origin of each of the cells forming part of a formula, including cells in other sheets, numeric values of the formula; and even cells originating from other workbooks.

Key functions of Formula Analyzer for Excel include:
  • Trace multiple precedents
  • Remove multiple precedents
  • Trace multiple dependents
  • Remove multiple dependents
  • Erase auditing arrows
  • In block formula's analyzer
  • Cell's reference tracker
  • Decompose Formula
  • Circular reference tracker
  • Error's tracker
  • Formula's translation
  • Translate
  • Translate formulas to labels
  • Translate formulas to values
  • Translate comment text
  • Settings
  • Chart Analysis
  • Arrange Windows
  • Toggle Settings
  • Sheets manager
  • Workbooks manager

Get It

(Pricing is available on the next page)
(Updated on 2023-11-01)

Related Excel Solutions for Formula Analyzer

Formula AuditingNavigation and Auditing  Team Collaboration ToolsModel Building  Convert 2007 VersionConverting and Integrating

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.