question

alchemicdreams avatar image
0 Votes"
alchemicdreams asked BK-1118 commented

Excel files on SharePoint 2019 seem to corrupt more often than in previous versions of SP

This is going to be a difficult one for people to replicate I'm sure but I thought it worth asking to see if the behaviour I am seeing is common / typical in SP19....

In our environment we are consistently having calls raised to us because of excel files becoming corrupt which users are working on from SP19 (using client app, not web app). Below screenshot demonstrates that the file becomes corrupt and shows as 0KB:

131047-screenshot-4.png



When users try to open the file they get an error message stating that the file format or file extension not valid. When they try to restore a previous working version even though version history looks like it has restored it, the file still won't load. It looks like the corruption extends to preventing the restore from happening.

At first I thought this was only happening on files where multiple users are trying to edit simultaneously, but today it has happened for a user who is the only person updating this excel file.

And final note, using the "open and repair" option from within excel also does nothing to fix it.

Anyone have any ideas? As I said, this is happening with excel files only. I've not had any reports of similar issues with word or powerpoint and we are dealing with a 2TB+ environment here.

office-sharepoint-server-administrationoffice-excel-itpro
screenshot-4.png (9.9 KiB)
· 9
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @alchemicdreams
Are there too many files in the library? Will the library with fewer files be better?

0 Votes 0 ·

Hi,

This is happening in libraries with very few files in them.

Thanks...

0 Votes 0 ·

Hello @alchemicdreams,
Our company recently migrated from SP13 to SP19, and we experience the very same issue.
Did you find a solution for your problem?

Kind Regards, Franz

0 Votes 0 ·

Hi,

No we never have found a solution for this and it still happens often enough that it is irritating. We have quite a robust backup and restore process in our organisation so currently I am just resorting to that when the crap hits the fan so to speak.

Cheers,
M

0 Votes 0 ·

@alchemicdreams , @BK-1118
Same here :(
It happens only once in a while, so we are going to live with that.
We found out, that you can restore the corrupted file via version history, when do it twice.
So, from your screen shot, restore version 0.327 and immediately after v 0.329 has been created, restore 0.327 again (without opening, reloading or any other action in between)
In our org, this happens only within Citrix Desktops and mainly for users who work with excel excessively (large lists, reports, vba, ...)

Do you have similar experience?

KR, Franz

0 Votes 0 ·
Show more comments

Hi @alchemicdreams. Did you ever find a solution for this? We are experiencing exactly the same situation. Thanks.

0 Votes 0 ·

Hi,

No we never have found a solution for this and it still happens often enough that it is irritating. We have quite a robust backup and restore process in our organisation so currently I am just resorting to that when the crap hits the fan so to speak.

Cheers,
M

0 Votes 0 ·

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered

Hi @alchemicdreams
As per my research, I couldn't find any effective method on this issue. I would suggest open a ticket with Microsoft to help you to troubleshoot.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.