Excel® 2013 On Demand

Using Inquire Tools

If you’re using Office Professional Plus, you can also use the Inquire tab (New!) to analyze, review, and compare workbooks in Excel. The Inquire is a COM add-in program, which may need to be loaded using the Add-In pane in Excel Options. The Inquire tab is a collection of tools that allows you to analyze and interactively report workbook problems or inconsistencies, view relationship diagrams—a graphical map of connection links—for workbooks, worksheets, or cells, and compare the content for multiple workbooks. You can also clean excess cell formatting to optimize and reduce the file size. If a workbook is password protected, you need to add it to the password list in Workbook Passwords, so Inquire can open saved copies for ...