How To Activate and Use The Inquire Tab?

In this article, we will learn how to activate and use the Inquire Add-in which is an inbuilt add in for Excel use.

Benefits of the Inquire addin

Let us understand what an Add-in is.

It allows you to extend Excel functionality across other platforms including Windows, Mac, iPad, and in a browser. Use Excel add-ins within a workbook to. Interact with Excel objects, read and write Excel data.

We can create the Excel Add-in from an Excel file itself which has some special functions which you feel are useful to other Excel files.

When we create an Add-in it is created in .xlam format. Many Excel add in's are downloaded from web with special functions to be used locally in you Excel files.

How To Add The Inquire to the Worksheet?

I will guide you how to use or import the Inquire Add-in to Excel file:

Open the Excel file in which you want the Add-in to be used.

Click FILE at the top left from Excel file.

Click Options at the bottom.

Inquire Options

Click Add-ins.

Inquire Add-ins

Select the Inquire Add-in from the list that you want to use.

Inquire addin

Then from the Manage select Com Add-in.

Inquire COM Add-ins

Click Go. Check Inquire and click go.

COM Add-ins Inquire

We are ready to use the inquire features now and it will be added to the toolbar.

Inquire Toolbar

Features of the Inquire addin

The inquire Add-in must have already been selected from the add-in options. Clicking the Inquire tab from Excel Tab will show these options:

  • Workbook Analysis
  • Workbook Relationship
  • Worksheet Relationship
  • Cell Relationship
  • Compare Files
  • Clean Excess Cell Formatting
  • Workbook Passwords

Inquire Ribbon tab

Now let us see the changes we can do with the inquire tool:

Clear Extra formatting

Sometimes the size of the file becomes excessively large and we can remove the extra formatting using inquire Add-in easily.

Let us see the file with excess formatting.

Now, use the option in inquire tab: "Clean Excess Cell Formatting".

Clean Excess Cell Formatting

The end result with all borders and colors removed.

Compare Files

When we are working on a file with daily changes and sometimes we might need to revert some wrongly applied changes and we don't know what we changed then we can easily check the old file with new file using compare files.

We will use the Compare Files to compare 2 files now. Lets click Compare Files button and select two files which you want to compare:

compare files inquire addin

Clicking compare will give results like this:

Inquire compare results

So we can clearly see the differences highlighted in green.

Now we can also export this differences report using the export button.

Again, you can also check the difference's in detail by checking the color details. This is help you to reconcile the file back to original as per the requirements.

Workbook /Worksheet Relationship

We can inquire a lot about the worksheet and workbook using these options which will become handy to understand complex financial worksheets.

Workbook Analysis

We can Analyze a lot about the worksheet and workbook using this options which will become handy to understand complex financial worksheets.

Go to the Excel ribbon and click Inquire tab. From the tab click Workbook Analysis button.

Workbook Analysis inquire

We will see these options.

Workbook Analysis Report options inquire

Let us run the results and check.

inquire run the results

This is how the example result of workbook analysis looks like.