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

Formula Analyzer

Excel formula analyzer for navigation and auditing

Excel Formula Analyzer

Rate this solution:
(4/5 from 2 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

Price: USD 35.90
(Updated on 2019-04-01)

Related Excel Solutions for Formula Analyzer

Formula AuditingNavigation and Auditing  Conditional Row DeletionTime Saving  Formula ManagementTime Saving  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.