Edit in Office functionality doesn't save changes to Confluence for Excel format.
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Users can download Excel files using Edit in Office. After a user makes changes to the Excel file, the file fails to update and save in Confluence. The changes are not observed in Confluence versioning or updated to the page.
Environment
- Confluence Server or Data Center (any version)
- Office 365
- Windows Operating System
Diagnosis
You're able to successfully "Edit in Office," and the file loads in Excel (Office 365). But when saving, the user is prompted with the following error:
UPLOAD FAILED
Your file wasn't uploaded because your changes can't be merged with changes made by someone else.
Cause
A Trust Center configuration is enabled in Protected view, causing changes not to be saved: Enable Protected View for files originating from Internet
For further information on this see: Upload failed: Server FIle Updated. We're sorry, someone updated the server copy and it's note possible to upload your changes now
Solution
We need to disable the setting Enable Protected View for files originating from Internet in Excel (Windows only).
1. Open Excel.
2. Navigate to Trust Center > Trust Center Settings
3. Deselect the checkbox for Enable Protected View for files originating from Internet and press OK.