PerfectXL Source Inspector 1.0.0

PerfectXL Source Inspector is an Excel Source Detection tool that provides quick scanning of Excel files to identify risks such as broken formula strings, incomplete or external references, and error-prone functions. It helps users understand the structure and flow of a spreadsheet by visualizing the connections between tabs, inputs, outputs, and VBA modules. PerfectXL Source Inspector also highlights potential vulnerabilities and inconsistencies, allowing users to efficiently maintain, repair, and improve the quality of their Excel models.

In addition, it supports version control by comparing different file versions and generating audit reports for comprehensive model evaluation. This tool is especially useful for complex spreadsheets that require quality assurance, error detection, and system auditing.

Features of PerfectXL Source Inspector

• Quickly scan for risks to identify major issues such as broken formula chains, incomplete or external references, and error-prone functions.
• Visualize information flow, showing connections between tabs, inputs, outputs, and external sources to clarify workbook structure.
• List and analyze all unique formulas for comprehensive formula testing and risk detection.
• Detect and visualize external data sources to efficiently manage and share linked resources.
• Identify and display circular references and their exact paths for easy resolution.
• Tools to Detect hard-coded numbers in formulas that could cause errors or confusion.
• Reveal hidden information, including very hidden worksheets, to maintain transparency.
• Clean up models by displaying unused and irrelevant information, allowing model simplification.
• Version control features to highlight differences between file versions and maintain an audit trail.
• Test against formal or informal Excel model guides to ensure quality standards.
• Generate audit reports with information flow blueprints and formula lists to perform due diligence.
• Identify error-prone or outdated functions with modern replacement recommendations.
• VBA modules and macro insights to manage legacy code and transition to modern versions of Excel.