Use Spreadsheet Compare to compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ – line by line, and cell by cell. Spreadsheet Compare can detect and highlight just the type of differences you specify.

Open Spreadsheet Compare. In the lower-left pane, choose the options you want included in the workbook comparison, such as formulas, cell formatting, or macros. Or, just Select All. On the Home tab, choose Compare Files. In the Compare Files dialog box, in the Compare row, browse to the earlier version of your workbook.

Click Home > Compare Files. The Compare Files dialog box appears. Click the blue folder icon next to the Compare box to browse to the location of the earlier version of your workbook. In addition to files saved on your computer or on a network, you can enter a web address to a site where your workbooks are saved.

The Compare Files command lets you see the differences, cell by cell, between two workbooks. You need to have two workbooks open in Excel to run this command. 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.

You'll see detailed changes in a new window, line by line. This comes in handy when you want to compare macros or Visual Basic for Applications (VBA) code. Let's walk through an example. Suppose you want to see how the VBA code has changed for a function you wrote named "GPA." Here's what the changes look like in the Spreadsheet Compare results ...

Basic tasks in Database Compare. Compare two versions of a database. See the details of changes between versions of a database. Export Access data to see record updates. Manage passwords used to open files for comparison. Import passwords from a text file. Use Database Compare to compare Access databases or two versions of the same database.

Browse to find the database that is "changed" (or the most recent version) by clicking the button to the right of the To box. Under Report Options, choose the database objects or items ( Tables, Queries, Macros, Modules, Reports, Forms, or Pages) you want compared by checking the boxes next to them.

Compare two Access databases. Open Database Compare. You’ll see a simple dialog box that has two tabs: Setup and Results.

To resolve the error, install Microsoft Report Viewer 2015 Runtime, which requires either the x64 version of SQLSysCLRTypes.msi, or the x86 version of SQLSysCLRTypes.msi, as appropriate, to be installed first. This article introduces the Database Compare tool now requires Microsoft Report Viewer 2015.

“ 比较文件 ”命令让您能够在两个工作簿之间逐个查看单元格的差异。 您需要在 Excel 中打开两个工作簿才能运行此命令。 结果将按内容种类进行彩色编码，如输入值、公式、命名区域和格式。 甚至有一个窗口可逐行显示 VBA 代码的更改。 单元格之间的差异以如下所示的易于阅读的网格布局显示： “ 比较文件 ”命令使用 Microsoft Spreadsheet Compare 来比较两个文件。 在 Windows 8 中，您可以通过单击“ 应用 ”屏幕上的“ Spreadsheet Compare ”在 Excel 外部启动 Spreadsheet Compare。