Microsoft Excel is an advanced Microsoft spreadsheet software program, included in the MS Office suite of applications. In addition to the basic functions of the spreadsheet, Excel is used to register, organize, analyze, format and manipulate numerical data. Besides that, Excel has graphic tools, dynamic tables and also VBA macro capabilities. Microsoft Excel is part of Microsoft Office Suite and is used for both personal and business purposes. XLS and XLSX are the two extensions for an Excel file and, thanks to backward compatibility, each file can be easily opened in either version.
But do you think that even after possessing such an impressive feature set, MS Excel is a complete test application? The answer to that is no! There are many unforeseen situations that Excel users may face when working with the application. Take the following problem scenario, for example.
Recently, a user contacted us saying that:
“I recently upgraded to Excel 2016 and I can not open existing Excel files from outside of Excel 2016 using the shortcuts or double-clicking on the icons.When I was using Excel 2013, it worked well in Windows 7 Professional.”
Problems like these are, of course, confusing. After all, why would an update from Microsoft ruin the functioning of the Excel application already installed? But it is a sad truth. There are times when an Excel file does not open after a recent MS Excel update or a Windows update. What are the reasons behind this problem and what can users do to repair Excel after the update?
Reasons behind the problem
These are some of the reasons why Excel files may not open after an update:
- Microsoft Excel has not been installed or updated correctly on your laptop / computer
It is possible that Excel files have been corrupted.
- Microsoft Excel can not access the default printer settings on the laptop / computer.
- Other third-party applications, such as TuneUp Utilities, Kaspersky Antivirus, Abby FineReader, etc. they can cause the problem.
- Sometimes, add-ons may be the reason for your problem.
- Your MS Office might be running in a compatibility mode for a version earlier than the current version of Windows that owns.
- Graphic hardware acceleration could be the problem.
- There may be some problems in the Protected View
Regardless of whether you can detect the exact trigger of the problem, you can try the solutions mentioned below to repair Excel files after the update.
How to repair Excel after the update?
You can try the following fixes to repair Excel files after the update:
Solution 1: Install updates
As a first step, update your Microsoft Excel and Windows to the last patch.
Solution 2: Restart and repair Excel
You can solve the problem by simply restarting Excel 2016. If you do not solve the problem, you must repair Excel by following these steps:
- Open the Windows Control Panel and go to the list of installed Programs.
- Click on the MS Office product that you want to repair and click Change.
- Follow the remaining instructions.
Solution 3: Reinstall Microsoft Office
Solution 4: Change your default installed printer
If the problem is due to a defective configuration of the printer, follow the steps outlined below:
- Close all open Office applications.
- Change your default printer by going to: Start -> Devices and printers. It may not necessarily be a physical one, it can be One Note or XPS or PDF or something else.
Note: Remember to update all printer drivers to the latest version of the Internet.
Solution 5: Check the programs that cause third-party problems
Sometimes, third-party applications, such as antivirus, etc. they can cause problems within Office programs. Try to close them all one by one and open the defective Excel file each time to see the effect.
Solution 6: Disable add-ins
To determine whether add-ins are the ones that create the problem, you must open Excel in Safe Mode and see if it helps. To open Excel in safe mode-
- Press and hold the Ctrl key on your keyboard and then click on the Excel icon.
- Otherwise, type “excel / safe” in the Run application and then press OK.
If the problem has been eliminated, restart Excel in normal mode and disable all add-ons one by one. You can try to determine which add-on is the main culprit by restarting Excel each time you disable one.
Solution 7: Disable graphical hardware acceleration
To disable graphical hardware acceleration, follow these steps:
- Open Excel
- Go to File -> Options
- Go to the Advanced tab -> Display
- Check the box ‘Disable graphic hardware acceleration’
- Click OK and then restart Excel
Solution 8: Fix problems with the protected view
Follow the steps mentioned below:
- Open Excel
- Go to File -> Options
- Select Trust Center -> Trust Center Configuration
- Click on Protected View
- Uncheck all options
Also change the configuration below
- In Trust Center Settings, go to ‘File Lock Settings’
- Uncheck all options
Hopefully one of the previous manual solutions will help you to repair Excel after the update. If not, you could be dealing with a very damaged file. In such case, to solve the problem, use the automated Excel repair tool, Stellar Phoenix Excel Repair.
The best alternative to manual solutions
Stellar Phoenix Excel Repair software is a professional utility to repair corruptions within Excel files. Competent and efficient software quickly scans even the most damaged Excel files and repairs them to facilitate the recovery of tables, forms, reports, cell data, formatting, etc. It is a complete DIY product equipped with an interactive graphical user interface and comes with a free preview feature that allows you to view recoverable data before saving repaired Excel file data.
I hope you like this article and have learned something new. Click Like, comment and share our articles if you really appreciate my work.
If you have any questions about this article, do not hesitate to ask me in the comments box below