Using Excel 2016 , my data is missing from Spreadsheets after Uninstalling Office 2010

Question

PC is running Windows 10. I recently upgraded to Office 365 from Office 2010. All of my documents and spreadsheets opened fine until I uninstalled Office 2010. After uninstalling Office 2010; If I go to file explorer and open a saved Excel spreadsheet that had data previously the spreadsheet opens blank, I then launch Excel and see the filename listed in the recents and when I open the file from there the spreadsheet opens correctly with the data, I can change the data and save it and the spreadsheet has the correct date/time in File Explorer but when I open it again from File Explorer it is missing its data. This only happened after I uninstalled Office 2010 and only with Excel, my Word Docs and Power Point files are ok. I have verified that the file extensions are associated with Excel 2016. Is there a fix to this?

Answer 1

Try following (First try option 5) -

1. Update your office as well as Windows 10 to latest patches from Microsoft site. Microsoft keeping releasing Office and Windows 10 patches to correct known errors.
2. Review the Article - Known issues with Office and Windows 10 - https://support.office.com/en-us/article/Known-issues-with-Office-and-Windows-10-28d56d84-c16c-4763-8eac-e51e05a37a16?ui=en-US&rs=en-US&ad=U
3. You may login to Windows with a new user profile and see if it helps.
4. Review following link - https://community.office365.com/en-us/w/manage/office-365-and-windows-10-problems-and-solutions
5. Repair the office installation - https://support.office.com/en-NZ/Article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b
6. Follow the instructions given on this page to make older programs compatible with Windows 10 - http://windows.microsoft.com/en-IN/windows-8/older-programs-compatible-version-windows 
7. For Ready Only Problems - Review the response of E. Harter at following link where sharing has solved the problem - http://answers.microsoft.com/en-us/office/forum/office\_2010-excel/2010-office-docs-all-open-as-read-only-after/31a64e6b-60e1-4d51-a897-9f8958660859

Also review the response of DADaveBaldwin1968 at following link

http://answers.microsoft.com/en-us/office/forum/office\_2010-excel/windows-10-changing-excel-2010-files-to-read-only/c893e995-4c68-47d4-98b5-656d3d54c0b2

Also review the response of ChadAddison at following link

http://answers.microsoft.com/en-us/office/forum/office\_2010-excel/read-only-mode/41d1fe6f-3eaf-4614-9b89-26c5764b455

8. Turn off Hey Cortana and reboot your computer (useful particularly if Excel performance is slow).
9. Right click on your Excel shortcut > Properties, In Compatibility tab, uncheck all options. Start the Excel again.
10. Right click on your Excel shortcut > Run as Administrator
11. Review the following thread - http://answers.microsoft.com/en-us/office/forum/office\_2013\_release-excel/cannot-open-some-office-files-after-upgrading-from/c103ee49-2e87-4421-ad96-f433ec77ec54
12. Sometimes, this is caused due to excel not being able to access the default printer. Close all office applications and change your default printer through Start > Devices and Printers to another printer. It may be some physical one or One Note or XPS or PDF or anything else. If this is the problem, then you will need to update your printer driver for default printer.
13. Many third party applications also cause the problem like Tuneup Utilities, Abby Finereader, Kaspersky Anti Virus  etc. See if you have any of them installed. Close them one by one and see whether it helps.
14. If above don't, re-installation of office may (and may not also) solve your problem. Remove MS Office completely by downloading Fixit tool and from http://support.microsoft.com/kb/2739501 and running it. Make sure that you have license keys ready before you attempt re-installation. If you don't have license keys, please do not attemp re-installation. You can also install MS Office by logging into www.office.com/myaccount if you have registered your copy.

Answer 2

Thank you.

Step 5 worked for me, 

5. Repair the office installation - https://support.office.com/en-NZ/Article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b