Q: In your April 2013 JofA article titled “Microsoft Office 2013,” page 32, you mentioned that Excel 2013 offers the ability to “compare two spreadsheets to display changes (similar to Word’s Compare tool),” but I can’t find this functionality. Can you please tell me where to find this tool?
A: To use Excel 2013’s new Compare tool, you must first activate the Inquire add-in from Excel’s File tab by selecting Options, Add-Ins. In the resulting Excel Options dialog box, from the Manage dropdown box in the lower-left corner, select COM Add-ins and click Go. In the resulting COM Add-Ins dialog box (pictured below), check the Inquire box and click OK.
In addition to the Compare tool, the Inquire tab also includes four new analysis tools, described below:
1. Workbook Analysis. To view a report detailing dozens of characteristics of a workbook, from the Inquire tab, select Workbook Analysis to launch the dialog box (pictured in the next screenshot in the background) and place a checkmark next to the characteristics you want to analyze. For example, you might choose to analyze warnings, errors, hidden items, or linked workbooks. After making your selections, click Excel Export, Save. In the resulting confirmation dialog box click Load Export File to view the summary report (pictured below in the foreground).
The first worksheet summarizes the analysis, and the worksheets that follow provide details for each analysis. This type of report might be useful to help analyze or better understand a complicated Excel file you did not author.
2. Workbook Relationship. To help manage workbooks with numerous connections, from the Inquire tab, select Workbook Relationship to display an interactive diagram of all related files, with arrows depicting the directional flow of links to those files.
Worksheet Relationship and Cell Relationship
tools. The Inquire tab’s
Worksheet Relationship and Cell
Relationship tools work similarly to the Workbook
Relationship tool but instead summarize links between sheets
for a specific workbook, or links to a specific cell address.