question

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

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)
· 2
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 ·

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.