Why Spreadsheet Compare and Office Tools Are Missing in Microsoft 365
Question details
The user is unable to locate the Office Tools folder or the Spreadsheet Compare feature in their Microsoft 365 or Office installation.
- Product
- Microsoft 365 / Microsoft Office
- Device & OS
- not provided
- Scenario
- Attempting to use the Spreadsheet Compare tool to analyze differences between Excel workbooks.
- Observed behavior
- The Spreadsheet Compare tool and the legacy Office Tools folder are completely missing from the start menu and installation directory.
Verify your current Microsoft Office version and subscription plan, as Spreadsheet Compare is only included in specific enterprise-level editions.
Check Your Microsoft 365 Edition and License
Determine if your specific Office version is licensed to include the Spreadsheet Compare feature.
Spreadsheet Compare is not available in standard, personal, or family editions of Microsoft 365. The feature is strictly limited to volume-licensed enterprise versions, specifically Office Professional Plus (2013, 2016, 2019) and Microsoft 365 Apps for enterprise.
Launch Microsoft Excel or Word and open a blank document.
Click on 'File' in the top-left corner of the ribbon, then select 'Account' from the bottom-left menu pane.
Look under the 'Product Information' section to see your exact Office edition. If it does not explicitly say 'Microsoft 365 Apps for enterprise' or 'Office Professional Plus', your license does not support Spreadsheet Compare.
Use an Alternative Workbook Comparison Tool
Utilize alternative or third-party macro-enabled workbooks to compare sheets if you lack an enterprise license.
Manage Spreadsheets Easily with WPS Office
Tired of dealing with confusing licensing restrictions for basic features? WPS Office is a highly compatible, free, and lightweight alternative to Microsoft Office. With WPS Spreadsheets, you can easily open, view side-by-side, and manage multiple Excel workbooks without expensive enterprise subscriptions.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen prompts to complete the setup.
- 3. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files instantly to start working.
Frequently Asked Questions
What happened to the Office Tools folder?
The Office Tools folder was discontinued in modern versions of Microsoft Office and Microsoft 365. The utilities previously stored there have either been integrated directly into the main applications, discontinued entirely, or restricted to specific enterprise editions.
Can I download Spreadsheet Compare separately?
No, Microsoft does not offer Spreadsheet Compare as a standalone download. It is heavily integrated into the installation of Office Professional Plus and Microsoft 365 Apps for enterprise and cannot be installed separately on other editions.
How can I compare two Excel sheets without Spreadsheet Compare?
You can open both workbooks, navigate to the 'View' tab, and select 'View Side by Side' to manually compare them. Alternatively, you can use conditional formatting, VLOOKUP formulas, or download third-party macro-enabled comparison workbooks.
