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:
- Make a copy of the corrupted file and work on the copy instead of the original file.
- 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.
- 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.