Sharepoint vs Excel XLSM file LOG ERROR 188760_01

Frazer, Paul 0 Reputation points
2024-04-23T14:26:32.01+00:00

Good day - will try to articulate the issue here. Multiple users will receive error messages and are unable to save a Sharepoint housed Excel XLSM file. Partial log file when running "Open and Repair" below (redacted user information):

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error188760_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\xxx\Downloads\xxx.xlsm'</summary>

<additionalInfo>

<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>

</additionalInfo>

</recoveryLog>

Also will randomly get an error such as "An unexpected error has occured. AutoRecover has been disabled for this session of Excel".

Trying to determine what could be root cause for this error. Any insight which can be returned would be much appreciated.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,831 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,678 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 21,611 Reputation points Microsoft Vendor
    2024-04-24T02:28:04.17+00:00

    Hi @Frazer, Paul ,

    The error message "Errors were detected in file" indicates that the Excel file is corrupted. This could be due to various reasons such as network issues, software conflicts, or hardware problems. The "An unexpected error has occurred" message could also be related to the corrupted file. To resolve this issue, you can try the following steps:

    1. Make a copy of the corrupted file and work on the copy instead of the original file.
    2. Try to open the file in Safe Mode by holding down the Ctrl key while opening Excel. This disables any add-ins or customizations that may be causing the issue.
    3. If none of the above steps work, you may need to restore a previous version of the file from SharePoint if version history is enabled.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.