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.

Use Spreadsheet Compare to find differences between two Excel workbooks.

On the Start screen, click Spreadsheet Compare. If you do not see a Spreadsheet Compare option, begin typing the words Spreadsheet Compare, and then select its option. In addition to Spreadsheet Compare, you'll also find the companion program for Access – Microsoft Database Compare.

See the fine details of your VBA code changes, line by line, highlighted by color, by double-clicking a line in the results grid of Spreadsheet Compare report.

Say you want to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets. If Microsoft Microsoft 365 or Office Professional Plus 2013 is installed on your computer, the Spreadsheet Inquire add-in is available in Excel.

Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu. Select the Microsoft 365 or Office product you want to repair and select Modify. Note: This will repair the entire Office suite even if it's just one application you want to repair such as Word or Excel.

Get Help has troubleshooters for Microsoft 365 you can run for many common scenarios. These often help resolve issues without the need to contact support. If a troubleshooter is available for your issue, select Start to run that troubleshooter. Available Microsoft 365 troubleshooters.

Learn how to download and install apps you need from your Microsoft 365 business subscription.

To install an add-in that is typically installed with Excel, such as Solver or the Analysis ToolPak, run the setup program for Excel or Microsoft Office and choose the Change option to install the add-in. After you restart Excel, the add-in should appear in the Add-Ins available box.

View, manage, and install add-ins for Excel, PowerPoint, and Word. When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.