Workbooks connected to other workbooks through cell references can get confusing.

The picture here shows a very simple workbook containing two formulas and data connections to an Access database and a text file. The Workbook Analysis command creates an interactive report showing detailed information about the workbook and its structure, formulas, cells, ranges, and warnings. To learn more about Spreadsheet Compare and comparing files, read Compare two versions of a workbook. In Windows 7, click the Windows Start button and then > All Programs > Microsoft Office 2013 > Office 2013 Tools > Spreadsheet Compare 2013. In Windows 8, you can start Spreadsheet Compare outside of Excel by clicking Spreadsheet Compare on the Apps screen. The Compare Files command uses Microsoft Spreadsheet Compare to compare the two files. Differences between cells are shown in an easy to read grid layout, like this: There's even a window that can show VBA code changes line by line. Results are color coded by the kind of content, such as entered values, formulas, named ranges, and formats. You need to have two workbooks open in Excel to run this command. The Compare Files command lets you see the differences, cell by cell, between two workbooks.

If you don't see the Inquire tab in the Excel ribbon, see Turn on the Spreadsheet Inquire add-in. The Inquire tab on the Excel ribbon has buttons for the commands described below. You can use the commands in the Inquire tab to do all these tasks, and more. If Microsoft Microsoft 365 or Office Professional Plus 2013 is installed on your computer, the Spreadsheet Inquire add-in is available in Excel. Say you want to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Office for business Microsoft 365 admin More.

Winmerge compare excel sheets