Image credits: I found this banner image on Gratisography: Moustache & Eyebrows Free Photo - By Ryan McGuire You might lose the last changes, but at least you haven’t lost everything. I have however learnt with Excel to rather copy and paste the content into a new Excel Workbook, then save this as the new document. Click on the ellipses next to the document and go to Version History:įind an older version of the document that you think still worked and open it by clicking on the hyperlinked modified date. (You can also go to, go to SharePoint, locate the site, go to the library, locate the document.)īelow you’ll see I’ve “found” my document, however even when I open it from the web, it still gives the corrupt message. For libraries synced from Teams, go to the Team, click on any of the Files Tabs, click on open in SharePoint and locate the document in the document library.
For OneDrive Files, go to, open OneDrive and locate the file. When you simply cannot open the document, best is to go to the web. Here you can select to view previous versions and then save and older copy as the new copy: There are different ways to get to the versions, when the file is not corrupt yet, it’s as easy as opening it, and going to the drop-down at the top of the document. No matter what I did, I couldn’t open that file from any of my devices. Here’s an example of an error message I received today, which inspired this post of course: This means that every edit you make, can be “rolled back”. OneDrive and SharePoint Online has till recently kept 500 versions of your files (will change soon to 100, read more here).
Click here to learn more or register (ZA link, should reroute to your region). Sign up to raise funds and awareness for all the dads, brothers, sons and friends in your life. Together we can make a difference for men’s health – in prostate cancer, testicular cancer, mental health and suicide prevention. I have way to many awesome men in my life that I want to be around when I grow old. Let’s see how we can work around this to save that file. It’s nice that #OneDrive and #SharePoint keeps versions of the files, but if you can’t open the file, it’s an issue. This happens to me occasionally, especially on those files that I edit often, across different devices and when the files have lots of formatting and formulas in. AAARGHH!!!! There is nothing as frustrating as receiving that “Excel cannot open the file….
0 kommentar(er)
