To compare two workbooks, you need to have both workbooks open in Excel. After the add-in is turned on, the Inquire tab will appear in Excel. In the COM Add-Ins dialogue box, make sure the Inquire check box is selected, and click OK.ħ. Make sure COM Add-ins is selected in the Manage field.Ħ.
To enable the Inquire add-in, follow these steps:Ĥ. Note: When trying this on your own computer, if you don’t see an entry for the Inquire add-in in the COM Add-Ins dialogue box, it’s because either your version of Office or Excel doesn’t include it, or your organization’s system administrator has made it unavailable. You are welcome to download the two workbooks here to practice this comparison exercise:Īpplies To: Microsoft ® Excel ® for Windows Office Professional Plus 2013 and Office 365 ProPlus.
#Compare two different sheets in excel for mac 2011 how to#
In this tip, you’ll discover how to enable the Inquire tab and compare workbooks using it. To do this, you will need to use the commands in the Inquire tab, however the Inquire tab is not enabled by default. You can use Microsoft Spreadsheet Compare to run a report on the differences, and investigate any of the problems it finds. It could be an issue such as totals that are manually entered instead of formula calculated that you want to check. Sometimes when working in Excel, you may want to compare two versions of a workbook to see what was changed.
0 kommentar(er)
