Say you want to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets. If Microsoft Microsoft 365Â is installed on your computer, the Inquire add-in is available in Excel.
You can use the commands in the Inquire tab to do all these tasks, and more. The Inquire tab on the Excel ribbon has buttons for the commands described below.
If you don't see the Inquire tab in the Excel ribbon in Excel for Windows, see Turn on the spreadsheet Inquire add-in.
Compare two workbooks
The Compare Files command uses Microsoft Spreadsheet Compare to show you the differences, cell by cell, between two workbooks. You need to have two workbooks open in Excel to run this command.
-
Select the Inquire tab on the Ribbon.
-
Select Compare Files.
Results are color coded by the kind of content, such as entered values, formulas, named ranges, and formats. There's even a window that can show VBA code changes line by line. Differences between cells are shown in an easy-to-read grid layout, like this:
To learn more about Spreadsheet Compare and comparing files, see Compare two versions of a workbook.
Analyze a workbook
The Workbook Analysis command creates an interactive report showing detailed information about the workbook and its summary, formulas, cells, ranges, and warnings. The picture here shows a very simple workbook containing two formulas and data connections to an Access database and a text file.
-
Select the Inquire tab on the Ribbon.
-
Select Workbook Analysis.
-
In the Items box, select what you'd like to analyze: summary, workbook, formulas, cells, ranges, and/or warnings. To learn more, see Analyze a workbook.
Show workbook links
Workbooks connected to other workbooks through cell references can get confusing. Use the Workbook Relationship Diagram to create an interactive, graphical map of workbook dependencies created by connections (links) between files. The types of links in the diagram can include other workbooks, Access databases, text files, HTML pages, SQL Server databases, and other data sources. In the relationship diagram, you can select elements, find more information about them, and drag connection lines to change the shape of the diagram.
-
Select the Inquire tab on the Ribbon.
-
Select Workbook Relationship Diagram.
This diagram shows the current workbook on the left and the connections between it and other workbooks and data sources. It also shows additional levels of workbook connections, giving you a picture of the data origins for the workbook.
To learn more, read See links between workbooks.
Show worksheet links
Got lots of worksheets that depend on each other? Use the Worksheet Relationship Diagram to create an interactive, graphical map of connections (links) between worksheets both in the same workbook and in other workbooks. This helps give you a clearer picture of how your data might depend on cells in other places.
-
Select the Inquire tab on the Ribbon.
-
Select Worksheet Relationship Diagram.
This diagram shows the relationships between worksheets in four different workbooks, with dependencies between worksheets in the same workbook as well as links between worksheets in different workbooks. When you position your pointer over a node in the diagram, such as the worksheet named "West" in the diagram, a balloon containing information appears.
To learn more, read See links between worksheets.
Show cell relationships
To get a detailed, interactive diagram of all links from a selected cell to cells in other worksheets or even other workbooks, use the Cell Relationship tool. These relationships with other cells can exist in formulas, or references to named ranges. The diagram can cross worksheets and workbooks.
-
Select the Inquire tab on the Ribbon.
-
Select Cell Relationship.
This diagram shows two levels of cell relationships for cell A10 on Sheet5 in Book1.xlsx. This cell is dependent on cell C6 on Sheet 1 in another workbook, Book2.xlsx. This cell is a precedent for several cells on other worksheets in the same file.
To learn more about viewing cell relationships, read See links between cells.
Clean excess cell formatting
Ever open a workbook and find it loads slowly, or has become huge? It might have formatting applied to rows or columns you aren't aware of. Use the Clean Excess Cell Formatting command to remove excess formatting and greatly reduce file size. This helps you avoid "spreadsheet bloat," which improves Excel's speed.
-
Select the Inquire tab on the Ribbon.
-
Select Clean Excess Cell Formatting.
Important:Â You may want to make a backup copy of your file before cleaning the excess cell formatting, because there are certain cases where this process may make your file increase in size, and there is no way to undo the change.
To learn more, see Clean excess cell formatting on a worksheet.
Manage passwords
If you're using the Inquire features to analyze or compare workbooks that are password protected, you'll need to add the workbook password to your password list so that Inquire can open the saved copy of your workbook. Use the Workbook Passwords command on the Inquire tab to add passwords, which will be saved on your computer. These passwords are encrypted and only accessible by you.
-
Select the Inquire tab on the Ribbon.
-
Select Workbook Passwords.
To learn more about using passwords to analyze workbooks, read Manage passwords used to open files for analysis and comparison.
See alsoÂ
Compare two versions of a workbook by using Spreadsheet Compare
Analyze a workbook with Spreadsheet Inquire
Clean excess cell formatting on a worksheet
Manage passwords used to open files for analysis and comparison
