<

Inquire Add-In for Excel 2013

Published on
18,176 Points
12,076 Views
1 Endorsement
Last Modified:
Approved
Today I'm going to talk about a great add-in for Excel 2013, which is part of Excel itself and is called Inquire. This Add-Inn hides tools that we have looked for in all previous versions of Excel but never found them. We then helped ourselves with some kind of a VBA solution, but never got even close to the elegance and simplicity of the Inquire Add-Inn.  This is in fact an analytical tool, which does not deal with numbers and tables, but rather with the data. Here’s what it can tell you... How many cells with formulas are in this workbook. How many blank sheets, how many hidden sheets…  How many connections between the sheets. How many links to other workbooks. How many differences are there between the two workbooks .The answers to all these questions, and many others are hidden in the INQUIRE tab, which can only be added to Excel by enabling the Inquire Add-In. Here’s how.
The procedure is very simple.  File/Options/Add-ins, select COM Add-ins and tick the Inquire. At this point I should also mention that PowerPivot is also already included, as you can see in the picture below.
 
Img1
Img2
Now, let’s take a walk through the ribbon. The first command is called Workbook Analysis, and gives you an extremely detailed analysis of the active workbook. Sample can be seen on the picture below.

Img3
As you can see it’s a comprehensive report on what is going on with your workbook, but you can even export the data into Excel.
After that are three very useful commands. The first one allows you to determine to which other workbooks the current workbook is associated to.

Img4
The next command tells you whether the formula or function in a workbook relates to other sheets.
 
Img5
The following command however, allows you to see everything that is taken into account in a calculation of a cell. So which cells are precedents or dependents of a certain cell. In previous versions there were commands Trace Precedents, and Trace Dependents, but for cells outside of the current sheet those commands completely lost transparency. But now a report for the active cell looks like this:

Img6
Easy and transparent.

But we saved the best for last. The following command was absent but missed in every previous version of Excel - Compare Files, where you can compare two workbooks, and Excel tells you what is different. The appearance of the tool:

Img7
Now get this, it will even tell you the differences between the VBA modules. Superior!
1
Comment
0 Comments

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Join & Write a Comment

This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month