1

I have a user that has an Excel file saved in a 2013 SharePoint on premises document library (versioning is not turned on). It is a .xls and he's been using it for some time and it's password protected. All of the sudden when he opens it (in Excel not the browser), then types in the password, he's getting "SharePoint file error: data may have been lost" message and he claims now he's missing a bunch of data previously added over a period of time.

The document is quite old, created in 2010 and the user says he's opened and saved it in the past with both Excel 2013 as well as 2016 and different computers.

When I open it, I do get the same error. And when I try to do a save as, Excel crashes and doesn't save it. I was able to download it to my computer using file explorer and open it, I still get the error but I can open it.

I can go into so much more detail but before I do I want to determine if this is a SharePoint issue or an Excel / user error? I'm leaning towards the latter!

  • Have you tried after saving file to desktop, changing the file extension to .xlsx or .xlsb and then tried opening? I have not seen your exact scenario, but this has fixed a couple Excel file issues with me in the past. – A.k.A. Fritz Mar 31 at 3:11
  • Yea, That's exactly what we ended up doing, changing the extension, but still lost some tables and graphs. – Marker Apr 1 at 14:05
0

File corruption in SharePoint happen, they are rare nevertheless I have seen more than few cases. I think it will be difficult to determine how the corruption of the file happened, was it while in storage on SharePoint or some invalid action from client machine. I would simply restore the file to the last known point it was working from the backup.

  • Thanks Marek, that's what I'm thinking too. – Marker Mar 11 at 12:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.