'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Cannot Open Old Excel Files After Installing Microsoft 365
Question details
Users are unable to open older Excel workbooks (.xls) after upgrading to or newly installing Microsoft 365.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to access and edit legacy spreadsheet files after completing a Microsoft 365 software update or installation.
- Observed behavior
- The old Excel files fail to launch, potentially displaying compatibility error messages, freezing the application, or simply not loading on the screen.
Before proceeding, note down the exact error message and verify whether your problematic files use the older .xls extension or the newer .xlsx extension to better isolate the issue.
Open Excel in Safe Mode and Disable Add-ins
Safe Mode bypasses add-ins and custom settings that frequently block older files from opening correctly after a Microsoft 365 upgrade.
In many cases, third-party COM add-ins that were compatible with older versions of Excel become incompatible with Microsoft 365, preventing legacy workbooks from launching.
Press the Windows key + R simultaneously on your keyboard to open the Run dialog box.
Type 'excel /safe' (without the quotes) into the text box and press Enter to launch Microsoft Excel in Safe Mode.
Navigate to File > Open and attempt to open your older Excel file. If it opens successfully, the issue is caused by an add-in.
Go to File > Options > Add-ins. In the Manage dropdown at the bottom, select 'COM Add-ins' and click Go. Uncheck the add-ins one by one and restart Excel normally to identify the culprit.
Clear the Excel XLSTART Folder
Corrupted template files or startup macros located in the XLSTART folder can interfere with older workbooks.
Easily Open Old Excel Files with WPS Office
If Microsoft 365 continues to struggle with your legacy workbooks, WPS Office provides excellent backward compatibility. It is a free, lightweight suite that effortlessly opens both old .xls and modern .xlsx files without the hassle of Safe Mode or registry tweaks.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to complete the setup in minutes.
- 3. Open Your Legacy Workbooks: Launch WPS Spreadsheets, click File > Open, and select your older Excel files. They will open seamlessly with full editing capabilities.
Frequently Asked Questions
Why does Microsoft 365 block older .xls files?
Microsoft 365 features updated security protocols, such as Trust Center and Protected View, which sometimes restrict legacy file formats to protect your computer from outdated vulnerabilities or macro-based threats.
Should I modify the Windows registry to fix Excel compatibility?
While advanced registry edits can resolve deep-rooted configuration issues, they carry a high risk of system damage. Always fully back up your registry before making changes, and try simpler methods like Excel Safe Mode or clearing the XLSTART folder first.
How do I know if my old Excel file is corrupted rather than just incompatible?
If your file fails to open in Excel Safe Mode, throws errors on other devices, or cannot be accessed using highly compatible alternative software like WPS Office, it is highly likely that the file itself is corrupted rather than facing a software compatibility issue.
