{"id":23152,"date":"2018-08-14T11:06:18","date_gmt":"2018-08-14T11:06:18","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=23152"},"modified":"2024-02-12T05:08:01","modified_gmt":"2024-02-12T05:08:01","slug":"fix-excel-file-after-latest-windows-update","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-file-after-latest-windows-update\/","title":{"rendered":"How to Repair Excel Files After Upgrade"},"content":{"rendered":"

Microsoft Excel is an advanced spreadsheet software program by Microsoft, included in the MS Office suite of applications. Apart from the basic spreadsheet features, Excel is used for recording, organizing, analyzing, formatting and manipulating numerical data. In addition to that, Excel features graphing tools, pivot tables and also VBA macro capabilities. Microsoft Excel is part of the Microsoft Office Suite and it is used both for personal and business objectives. XLS file<\/a> and XLSX file are the two extensions for an Excel and thanks to backward compatibility each file can be easily opened in any of the two versions.<\/p>

But do you think even after possessing such an impressive suite of features MS Excel is a full-proof application? The answer to that is no! There are a lot of unforeseen situations that Excel users can face when working with the application. Take the following problem scenario for example.<\/p>

Problem Scenario<\/strong><\/h2>

We were recently contacted by a user who claimed that:<\/strong><\/p>

“<\/em>I recently upgraded to Excel 2016 and I am unable to open existing Excel files from outside Excel 2016 using the shortcuts or double clicking on icons. When I was using Excel 2013, it was working fine on Windows 7 Professional.”<\/em><\/p>

Problems like these are of course confusing. After all, why would an update from Microsoft mess up the working of the already installed Excel application? But it is a sad truth. There are times when an Excel file doesn’t open after a recent MS excel upgrade or Windows upgrade. What are the reasons behind such an issue and what can users do to repair Excel after upgrade?<\/p>

Reasons Behind the ‘Unable to Open Excel File’ Issue<\/strong><\/h3>

Here are some of the reasons why Excel files might not open after an upgrade:<\/strong><\/p>

    \n
  1. Microsoft Excel hasn’t been correctly installed or upgraded on your laptop\/computer<\/li>\n\n\n\n
  2. The Excel files might have been corrupted<\/li>\n\n\n\n
  3. Microsoft Excel is not able to get access to the default printer setup on the laptop\/computer<\/li>\n\n\n\n
  4. Other third-party applications such as Tuneup utilities, Kaspersky Antivirus, Abby FineReader, etc. may cause the problem<\/li>\n\n\n\n
  5. Sometimes add-ins can be the reason behind your problem<\/li>\n\n\n\n
  6. Your MS Office might be running in a compatibility mode for a prior version than the current version of Windows you own<\/li>\n\n\n\n
  7. Hardware Graphic Acceleration might be the issue<\/li>\n\n\n\n
  8. There might be some issues in the Protected View<\/li>\n<\/ol>

    Regardless of whether you’re able to spot the exact trigger for the issue, you can try the below mentioned solutions to repair Excel files after upgrade.<\/p>

    Solutions to Repair Excel After Upgrade<\/strong><\/h2>

    You can try the below fixes to repair Excel files after upgrade:<\/p>

    Solution 1:<\/span> Install Updates<\/strong><\/h3>

    As a first step, update your Microsoft Excel and Windows to the latest patch.<\/p>

    Solution 2:<\/span> Restart & Repair Excel<\/strong><\/h3>

    You can fix the issue by simply restarting Excel 2016. If it doesn’t fix the issue, you need to repair Excel by following these steps:<\/p>

      \n
    • Open Windows Control Panel and go to the list of installed Programs<\/li>\n\n\n\n
    • Click the MS Office product you want to repair and click on Change<\/li>\n\n\n\n
    • Follow remaining instructions<\/li>\n<\/ul>

      Solution 3:<\/span> Reinstall Microsoft Office<\/strong><\/h3>

      Solution 4:<\/span> Change your default installed printer<\/strong><\/h3>

      If the issue is due to faulty printer setup, follow the below-mentioned steps:<\/p>

        \n
      • Close all open Office applications<\/li>\n\n\n\n
      • Change your default printer by going to: Start -> Devices and Printers. It may not be necessarily a physical one, it may be One Note or XPS or PDF or anything else.<\/li>\n<\/ul>

        Note:<\/strong> Remember to upgrade all the Printers Drivers to the latest version from the internet.<\/p>

        Solution 5:<\/span> Check third-party problem causing programs<\/strong><\/h3>

        Sometimes third-party applications like antivirus utilities, etc. can cause issues within Office programs. Try closing all of them one by one and open the faulty Excel file each time to see the effect.<\/p>

        Solution 6:<\/span><\/strong> Disable Add-ins<\/strong><\/h3>

        To determine whether add-ins are the ones creating the issue, you need to open Excel in Safe Mode and see if it helps. To open excel in safe mode-<\/p>

          \n
        • Press and hold the Ctrl key on your keyboard and then click on the Excel icon.<\/li>\n\n\n\n
        • Otherwise, type “excel \/safe” in the Run application and then press OK<\/strong>.<\/li>\n<\/ul>
          \n
          \"Excel<\/figure>\n<\/div>

          If the problem has been eliminated, restart Excel in normal mode and disable all add-ins one by one. You can try to determine which add-in is the main culprit by restarting Excel every time you disable one.<\/p>

          Solution 7:<\/strong><\/span> Disable the Hardware Graphic Acceleration<\/strong><\/h3>

          To disable Hardware Graphic Acceleration, follow these steps:<\/p>

            \n
          • Open Excel<\/li>\n\n\n\n
          • Go to File -> Options<\/li>\n\n\n\n
          • Go to Advanced tab -> Display<\/li>\n\n\n\n
          • Check the box for ‘Disable Hardware Graphic Acceleration’<\/li>\n<\/ul>
            \n
            \"Excel<\/figure>\n<\/div>
              \n
            • Click OK and then restart the Excel<\/li>\n<\/ul>

              Solution 8:<\/span> Fix issues with Protected View<\/strong><\/h3>

              Follow the below mentioned steps:<\/p>

                \n
              • Open Excel<\/li>\n\n\n\n
              • Go to File ->Options<\/li>\n\n\n\n
              • Select Trust Centre ->Trust Centre Settings<\/li>\n<\/ul>
                \n
                \"Trust<\/figure>\n<\/div>
                  \n
                • Click on Protected View<\/li>\n\n\n\n
                • Uncheck all options<\/li>\n<\/ul>
                  \n
                  \"Uncheck<\/figure>\n<\/div>

                  Also change the below settings<\/strong><\/p>

                    \n
                  • Under Trust Centre settings, go to ‘File Block Settings’<\/li>\n\n\n\n
                  • Uncheck all options<\/li>\n<\/ul>
                    \n
                    \"File<\/figure>\n<\/div>

                    Hopefully one of the above manual solutions should help you repair Excel after upgrade. If it doesn’t, you might be dealing with a heavily corrupted file. In such a case, to overcome the issue use automated Excel repair utility, Stellar Repair for Excel<\/strong>.<\/p>

                    The best alternative to manual solutions<\/strong><\/h2>

                    Stellar Repair for Excel software is a professional utility to fix corruptions within Excel files.<\/p>

                    \n