Summary: Are you unable to open Excel file after upgrading to a new version? Read this blog to know the possible reasons behind such an issue. Also, find the solutions on ‘how to repair Excel files after upgrade?'. If you are worried about losing your crucial spreadsheet data, try using a specialized Excel file repair tool to repair the file and recover all its data.
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 and XLSX are the two extensions for an Excel file and thanks to backward compatibility each file can be easily opened in any of the two versions.
Following the upgrade to 2016, I opened my workbook in Excel 2016 and ran the same procedure and it took 45 minutes. The other disturbing things I noticed were the following: The PowerPivot window takes an eternity to load up. When finally opening the Data Model window Excel lurches into a state of trying to refresh all of the queries I have.
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.
Organize, visualize and extract insights from your data more easily than ever with powerful new features. Save time with help from Excel. It finds patterns using intelligence and organizes data. Pubg g mobile emulator. Easily build spreadsheets with templates or your own format and perform calculations with modern formulas. Trusted Windows (PC) download Update for Microsoft Excel 2013 (KB2760339) 15.0.4833.1000. Virus-free and 100% clean download. Get Update for Microsoft Excel 2013 (KB2760339) alternative downloads.
Directv video player problem. Microsoft Excel 2013 is designed to help you get professional-looking results with features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you. Microsoft has released an update for Microsoft Excel 2016 64-Bit Edition. This update provides the latest fixes to Microsoft Excel 2016 64-Bit Edition. Additionally, this update contains stability and performance improvements.
Problem Scenario
We were recently contacted by a user who claimed that:
'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.'
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?
Reasons Behind the ‘Unable to Open Excel File' Issue
Here are some of the reasons why Excel files might not open after an upgrade:
- Microsoft Excel hasn't been correctly installed or upgraded on your laptop/computer
- The Excel files might have been corrupted
- Microsoft Excel is not able to get access to the default printer setup on the laptop/computer
- Other third-party applications such as Tuneup utilities, Kaspersky Antivirus, Abby FineReader, etc. may cause the problem
- Sometimes add-ins can be the reason behind your problem
- Your MS Office might be running in a compatibility mode for a prior version than the current version of Windows you own
- Hardware Graphic Acceleration might be the issue
- There might be some issues in the Protected View
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.
Solutions to Repair Excel After Upgrade
You can try the below fixes to repair Excel files after upgrade:
Solution 1: Install Updates
As a first step, update your Microsoft Excel and Windows to the latest patch.
Solution 2: Restart & Repair Excel
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:
- Open Windows Control Panel and go to the list of installed Programs
- Click the MS Office product you want to repair and click on Change
- Follow remaining instructions
Solution 3: Reinstall Microsoft Office
Solution 4: Change your default installed printer
If the issue is due to faulty printer setup, follow the below-mentioned steps:
- Close all open Office applications
- 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.
Note: Remember to upgrade all the Printers Drivers to the latest version from the internet.
Solution 5: Check third-party problem causing programs
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.
Solution 6:Disable Add-ins
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-
- 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-ins one by one. You can try to determine which add-in is the main culprit by restarting Excel every time you disable one.
Solution 7:Disable the Hardware Graphic Acceleration
To disable Hardware Graphic Acceleration, follow these steps:
- Open Excel
- Go to File -> Options
- Go to Advanced tab -> Display
- Check the box for ‘Disable Hardware Graphic Acceleration'
- Click OK and then restart the Excel
Solution 8: Fix issues with Protected View
Follow the below mentioned steps:
- Open Excel
- Go to File ->Options
- Select Trust Centre ->Trust Centre Settings
- Click on Protected View
- Uncheck all options
Upgrade Office 2013
Also change the below settings
- Under Trust Centre settings, go to ‘File Block Settings'
- Uncheck all options
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.
The best alternative to manual solutions
Stellar Repair for Excel software is a professional utility to fix corruptions within Excel files.
The competent and efficient software quickly scans even the most severely corrupted Excel files and repairs them to facilitate the recovery of tables, forms, reports, cell data, formatting etc. from them. It is a complete DIY product equipped with an interactive GUI and comes with a free preview feature which lets you view recoverable data before saving the repaired Excel file data.
Final Words
Hope you'll be able to repair Excel files after an upgrade by using one of the above fixes. Remember to always backup your critical files to avoid data loss situations. If nothing works, you can place your trust in reliable products like Stellar Repair for Excel.
So, what are your views on this? Do let us know in the comments below.
If you've been an Office user for a long time, you've probably noticed the tremendous changes that Microsoft has made over the years. Since the year 2000, you've worked with Office 2000, XP, 2003, 2007, 2010 and 2013. Each of these versions introduced new improvements to your work day.
Find out how Sherweb can help your business grow with our Partner Guide
The Office suite is now more than just a set of tools for word processing, spreadsheets, presentations, publishing, and email messaging. Productivity has been brought to a higher level with sharing, co-authoring, mobility and more. However, there are differences between versions. Let's compare how Office 2016 differs from 2013 and 2010.
If you've been stuck with an earlier version of Office, you probably have a good reason. You may have third-party tools integrated with the software, or other business constraints that don't allow you to upgrade. Or, you simply haven't found the time to think about it. If you've had compatibility issues, you've probably installed free Office Viewers and you think it does the trick.
You might have valid reasons for sticking with an older version of the Office suite. But keep this in mind: your business data is a financial asset that has to be protected. Will Office 2016 help you do this? Yes, and a lot more.
Call of duty black ops 4 beta website. We've compared the two previous versions of the Office suite with Office 2016 based on the following elements:
Office 2016 is built for teamwork
| Teamwork Features | Office 2010 | Office 2013 | Office 2016 |
| Co-author like never before in Word, PowerPoint and OneNote. | |||
| Basic co-authoring (ability to edit in parallel) | |||
| Real-time typing in Word lets you see others' edits as they make them. | |||
| Improved version history | |||
| Share button in ribbon in W/X/P | |||
| Thanks to Skype in-app integration, you can IM, screen share, talk or video chat right in your docs. | |||
| Skype Meetings offers HD video, desktop sharing, co-authoring, presentations, and more. | |||
| Skype Meetings | |||
| HD Video and co-authoring | |||
| Office 365 Groups now available as part of Outlook and on iOS, Android, and Windows | |||
| With OneNote shared notebooks, you have one place to share and see notes | |||
| Take your Office anywhere with a set of Office mobile apps across Windows, Android, and iOS. |
Office 2016 works for you
| Works for you Features | Office 2010 | Office 2013 | Office 2016 |
| Outlook 2016 is built to give you lightning fast search, remove low priority mail, and make sure everyone has the right access with Modern Attachments | |||
| Outlook Clutter in 2016 | |||
| Most recently used documents in Outlook | |||
| Modern attachments | |||
| Improved autosuggest search | |||
| Your most recently used documents list travels with you across your devices. | |||
| Excel 2016 is the most powerful analysis tool in your arsenal | |||
| Integrated Power Pivot (integration new in 2016) | |||
| Integrated Get & Transform and 3D Maps (integration new in 2016) | |||
| One-Click forecasting | |||
| New chart types | |||
| Publish to Power BI | |||
| Just type the word and Tell Me takes you directly to the feature you need. | |||
| Smart Lookup brings insights from the web right into your Office docs. |
Office 2016 is perfect on Windows 10
| Windows 10 Features | Office 2010 | Office 2013 | Office 2016 |
| Windows Hello logs you into your PC and Office – all in one simple step. | |||
| Let Cortana with Office 365 integration help with tasks like meeting prep | |||
| Office Mobile apps on Windows 10 are touch-friendly, fast, and optimized for on-the-go. | |||
| Continuum & Office Mobile apps on Windows 10 phones. Use your phone like a PC. | |||
| OneDrive storage & Windows 10 is a built-in, secure way to store and share all your stuff. |
Office 2016 is secure
| Security Features | Office 2010 | Office 2013 | Office 2016 |
| Data Loss Prevention helps significantly reduce the risk of leaking sensitive data, by giving IT admins tools to centrally create, manage and enforce policies for content authoring and document sharing. (Word, Excel, PowerPoint, Outlook) | |||
| Multi-factor Authentication allows you to securely access content anywhere – even when you're away from the corporate network. (Word, Excel, PowerPoint, Outlook) | |||
| Information Rights Management helps you encrypt your data online and off. | |||
| Word, Excel, PowerPoint, Outlook | |||
| Visio |
Excel 2016 Update
Office 2016 offers flexible Click-to-Run options
| IT Admin Features | Office 2010 | Office 2013 | Office 2016 |
| With deferred updates, you choose when you update—once a month or every three months and validate up to four months prior to deployment. | |||
| Improved integration with System Center Configuration Manager for efficient distribution of updates. | |||
| New Background Intelligence Transfer Service (BITS) provides better network traffic management. | |||
| Simplified activation management, with new controls in Office 365 Admin Portal that allow admins to manage device activations across users. |
Office 2016 has improved Outlook performance
| Outlook performance Features | Office 2010 | Office 2013 | Office 2016 |
| New Internet-friendly MAPI-HTTP protocol enhances Exchange/Outlook connectivity. | |||
| Outlook is more responsive on unreliable networks with the elimination of foreground network calls. | |||
| Reduced time to download messages, display the message list, and show new email after hibernation. | |||
| New settings let users better manage storage by only retaining 1, 3, 7, 14 or 30 days of mail on a device. |
Why upgrade to Office 2016? Collaborate better and be more productive
You can still buy Office in the usual 'one box, one installation' perpetual license from retailers. However, it is also available in a Software-as-a-Service model. One license gives you the right to install Office apps on five PCs, five Macs and five mobile devices. Subscription fees start at less than $10 per seat per month. Office Apps are available in an online mode, using a web browser, when you cannot install them locally.
With Office Apps, there's no upfront investment and you're guaranteed to always have access to the latest version.
