MS Excel - Inquire Add-in for Spreadsheet Analysis in MS Excel

The Inquire Add-in is a powerful Excel tool designed to help users analyze, audit, compare, and document workbooks. It is especially useful for professionals who work with large and complex spreadsheets containing multiple worksheets, formulas, external links, hidden data, and interconnected workbooks. The add-in helps identify potential errors, inconsistencies, and structural issues that may otherwise be difficult to detect manually.

The Inquire Add-in is available in certain Microsoft Office editions, particularly Microsoft 365 Apps for Enterprise, Office Professional Plus, and some business-oriented versions of Excel.

Purpose of the Inquire Add-in

As spreadsheets become larger and more complex, managing and verifying data accuracy becomes challenging. A workbook may contain hundreds of formulas, multiple worksheets, hidden cells, external references, and linked workbooks. The Inquire Add-in helps users understand the structure of these workbooks and identify areas that need attention.

Its primary objectives include:

  • Auditing workbook contents

  • Detecting hidden elements

  • Comparing workbook versions

  • Identifying formula inconsistencies

  • Analyzing workbook relationships

  • Documenting spreadsheet structures

  • Reducing risks associated with spreadsheet errors

Enabling the Inquire Add-in

To use the Inquire Add-in:

  1. Open Excel.

  2. Click File.

  3. Select Options.

  4. Choose Add-ins.

  5. In the Manage dropdown, select COM Add-ins.

  6. Click Go.

  7. Check the box for Inquire.

  8. Click OK.

Once enabled, a new "Inquire" tab appears on the Excel ribbon.

Key Features of the Inquire Add-in

Workbook Analysis

Workbook Analysis generates a comprehensive report about the structure and contents of a workbook.

The report includes information such as:

  • Number of worksheets

  • Number of formulas

  • Hidden sheets

  • Hidden rows and columns

  • External links

  • Data connections

  • Named ranges

  • Errors

  • Conditional formatting rules

This report helps users quickly understand workbook complexity and identify areas requiring further investigation.

Example

Suppose a financial workbook contains 25 worksheets and thousands of formulas. Running Workbook Analysis can reveal:

  • Hidden worksheets containing calculations

  • External links connected to old files

  • Cells with formula errors

  • Excessive formatting that increases file size

This saves significant time compared to manually inspecting every worksheet.

Workbook Relationship Diagram

Large organizations often use multiple linked workbooks.

The Workbook Relationship Diagram visually displays:

  • Connected workbooks

  • External references

  • Data dependencies

Users can see how information flows between different Excel files.

Benefits

  • Understand workbook architecture

  • Identify broken links

  • Track data sources

  • Improve documentation

For example, a budgeting workbook may obtain data from sales, inventory, and payroll workbooks. The relationship diagram shows these connections clearly.

Worksheet Relationship Diagram

This feature focuses on relationships within a single workbook.

It displays:

  • Worksheet dependencies

  • Data flow between sheets

  • Formula references

Users can determine which worksheets depend on others.

Practical Use

Consider a workbook containing:

  • Raw Data Sheet

  • Calculation Sheet

  • Dashboard Sheet

The diagram visually illustrates how data moves from one sheet to another, making troubleshooting easier.

Cell Relationship Diagram

The Cell Relationship Diagram allows users to trace formula dependencies at the cell level.

It shows:

  • Precedent cells

  • Dependent cells

  • Formula chains

This is particularly useful when investigating calculation errors.

Example

If a final profit calculation appears incorrect, the diagram helps identify every cell contributing to the result.

Users can follow the entire calculation path and locate incorrect values or formulas.

Compare Files

One of the most valuable features of the Inquire Add-in is Workbook Comparison.

Organizations often maintain multiple versions of the same workbook. Tracking changes manually can be difficult.

The Compare Files tool compares two workbooks and highlights:

  • Formula changes

  • Data changes

  • Formatting differences

  • Worksheet additions or deletions

  • Structural modifications

Example

Suppose Version 1 and Version 2 of a financial report exist.

The comparison report may show:

  • Revenue formula modified

  • New worksheet added

  • Formatting changes applied

  • Certain values updated

This ensures transparency and prevents accidental errors.

Cell Relationship Reports

The Inquire Add-in can generate detailed reports showing how specific cells interact.

These reports help users:

  • Understand formula dependencies

  • Validate calculations

  • Audit complex models

Financial analysts often use these reports when reviewing budgeting and forecasting models.

Cleaning Excess Cell Formatting

Many workbooks become unnecessarily large because of excessive formatting.

Users may accidentally apply formatting to entire rows or columns beyond the actual data range.

The Inquire Add-in includes a Clean Excess Cell Formatting tool that:

  • Removes unnecessary formatting

  • Reduces workbook size

  • Improves performance

  • Speeds up file opening and saving

Benefits

  • Smaller file size

  • Better performance

  • Easier maintenance

This feature is particularly useful for workbooks shared across teams.

Detecting Hidden Elements

Hidden content often creates confusion and auditing challenges.

Workbook Analysis can identify:

  • Hidden worksheets

  • Hidden rows

  • Hidden columns

  • Hidden names

  • Hidden formulas

This ensures complete transparency when reviewing spreadsheets.

Importance

In business environments, critical calculations may sometimes reside in hidden sheets. Detecting these elements prevents accidental oversight.

Formula Consistency Checking

Large worksheets often contain thousands of formulas.

The Inquire Add-in helps identify:

  • Inconsistent formulas

  • Formula errors

  • Unexpected formula patterns

For example, if most cells in a column use one formula but a single cell uses a different formula, the add-in flags the inconsistency.

This helps prevent calculation mistakes that could affect reports and decisions.

External Link Analysis

Many workbooks rely on external data sources.

The add-in identifies:

  • Linked workbooks

  • Data connections

  • External references

Users can verify whether these links are still valid and determine whether outdated references should be removed.

Advantages of the Inquire Add-in

Improved Accuracy

The add-in helps identify formula errors, inconsistencies, and hidden data.

Faster Auditing

Complex workbooks can be analyzed in minutes rather than hours.

Better Documentation

Relationship diagrams provide clear documentation of workbook structure.

Enhanced Transparency

Hidden worksheets, links, and dependencies become visible.

Risk Reduction

Organizations can reduce spreadsheet-related risks and improve confidence in reporting.

Limitations of the Inquire Add-in

Despite its usefulness, the Inquire Add-in has certain limitations:

  • Not available in all Excel editions.

  • Requires some understanding of workbook structures.

  • Analysis reports can become lengthy for very large files.

  • Does not automatically correct all detected issues.

Users must review findings and take appropriate corrective actions.

Best Practices

  1. Run Workbook Analysis before sharing important spreadsheets.

  2. Compare workbook versions before finalizing reports.

  3. Review relationship diagrams when inheriting spreadsheets from other users.

  4. Regularly check external links and dependencies.

  5. Clean excess formatting to maintain workbook performance.

  6. Investigate all flagged formula inconsistencies.

  7. Document workbook structures for future maintenance.

Conclusion

The Inquire Add-in is one of Excel's most valuable auditing and analysis tools. It provides deep insights into workbook structure, formulas, dependencies, links, and hidden elements. Features such as Workbook Analysis, Relationship Diagrams, File Comparison, Formula Auditing, and Formatting Cleanup help users maintain accuracy, transparency, and efficiency in complex spreadsheets. For analysts, accountants, auditors, and business professionals, the Inquire Add-in serves as an essential tool for ensuring spreadsheet reliability and reducing the risk of costly errors.