"Cant save your changes" - SharePoint - EXCEL

Question

Hi All,

I am currently having an issue where my team and I are working in an excel document through a SharePoint and every time we try to add in data (such as images) we run into the error message "We're sorry, we cannot merge your changes with the latest changes made by Named user"

with the only two options of this pop up being, save a copy or Discard my changes (image attached)

I should say that all users are going into the SharePoint via Microsoft teams (new), and then opening the file via the desktop app and editing in there as the online file does not allow for all the features required.

If anyone can help solve this issue or provide a work around it would be much appreciated.

Thanks

Callum

Answer 1

Hi @Callum Hawkins-Row,

Thank you for posting in this community.

Your question seems to be related to the co-editor. We need to narrow down the problem and try some things.

1.First of all, it is very likely that your co-authoring feature is blocked.

You can refer to this article (Troubleshoot co-authoring in Office) to confirm if some of your actions are blocking the co-authoring feature.

2.Please try to update your office to the latest version.

Firstly, to avoid data loss, I recommend you click Save a Copy to save your change. Then update Office via Open a spreadsheet > file > account > update options > update now. Then edit in the file and see if issue still happens.

3.Please check if your other users are experiencing the same problem.

Please try using another user's computer and account to see if the problem persists.

4.Please check if there are problems with all the excel files.

Please try creating a new excel file and opening it the same way to see if the problem persists.

5.Delete the Cache in Office Upload Center and check whether you can save or not.

Click on Windows key> Enter Office Upload Center> Click on it to Open> Settings> Delete cached file> Ok.

6.Please make sure that SharePoint's co-editing feature is working properly.

Please try creating the excel file directly on SharePoint (not sure if you are using on-prem or online) and then see if the problem persists when co-editing.

---

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.

Answer 2

Hi @Callum Hawkins-Row,

Thank you for posting in this community.

By your description, do you want to add or modify the background image of the cell?

If yes, then by the comment method if it doesn't work then we can try other methods to add images to the cells.

Using the Shape Feature to Insert Picture in Excel Cell Background：

• Firstly, from the Insert tab >>> Shapes >>> select Rectangle.

After that, the cursor will transform into a plus (+) sign.

• Secondly, draw a rectangle on cell D5.

• Thirdly, right-click on the rectangle >>> select Format Shape…

The Format Picture dialog box will appear.

• After that, from Fill & Line >>> select Picture or texture fill.
• Then, select Insert… under Picture source.

The Insert Pictures dialog box will appear.

• Click on From a File.

Another dialog box will appear.

• Select your desired picture.
• Finally, click on Insert.

The picture will appear on cell D5.

• Now, double-click on the image to enable write mode.
• Finally, type your words there.

---

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.