Excel TV ExcelTV
Excel Tips & Tricks

Inquire – Workbook Analysis in Excel

Updated
Inquire – Workbook Analysis in Excel

Troubleshooting Excel workbooks of others can be mind-numbing, if not excruciating. There are various tools that VBA experts have developed over the years to help with this process. But there is one great tool that is rarely mentioned.

Developed by Microsoft itself, INQUIRE is available in the Office Professional Plus and Office 365 Professional Plus editions. And Oz is already here to deliver a small, useful tutorial.

Let’s get started!

1 – Enabling INQUIRE in Excel

Enabling this add-in is really simple. Just follow these steps:

  1. Go to File > Options > Add-Ins.
  2. Make sure COM Add-insis selected in the Manage box, and click Go.
  3. Tick the box next to INQUIRE and click OK.

Of course if you have DEVELOPER tab activated, you can access COM Add-ins through it directly. The following image shows what it looks like.

1

If you can’t see INQUIRE amongst your COM Add-ins, it is because either your version of Microsoft Office doesn’t support it or that your organization’s system administrator has disabled it.

2 – Workbook Analysis

Highlighted in the image above, Workbook Analysis is an indispensable tool for anyone who has to do a lot of reviews or troubleshooting on Excel files.

When you click on it, this tool will run a bunch of analyses on your workbook before presenting you with a list of items. From this list, as shown in the image on the right, you can select various things you would like to see the reports on. Once you are done selecting, click on Excel Export and save the file.

2

3 – The Results

The reports are given in different sheets. And the amount of detail given is just tremendous. From Hidden and Very Hidden sheets to formulas with numeric inputs, everything is reported on. Some of the useful things to look at are as follows:

  • Blank referenced cells: to see if some inputs have been unintentionally left out.
  • Unused input cells: to see if some numeric values have not been used in any formula.
  • Inconsistent formulas: to see formulas which couldn’t have been copied (or dragged) from neighboring cells.
  • Numeric constant formulas: to see formulas with hard-coded numbers.3

4 – Usefulness

Some of the most apparent uses of this tool would be in troubleshooting a problem, detecting formulas with hard-coded inputs and providing comments on various parts of the file.

What’s next?

Take out an old file and try this tool out. The ease with which you can analyze workbooks through INQUIRE is definitely going to surprise you. And do not forget to write to us with your experiences.

Written by

Jamani Arsalan
Jamani Arsalan

Consultant, International Professional Services

  • Project Management
  • Statistical Analysis
  • Health Analytics
I am a consultant, currently based in Middle East, at an international professional services firm. My work largely revolves around project management, and statistical analysis. And my professional interests include developing my knowledge within the discipline of health analytics.

Read more articles by Jamani Arsalan

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.

Comments (1)

Historical comments preserved from the WordPress archive. Commenting is no longer active.

  1. J Kennedy

    any reason why inquire is disabled by default?