Receiving error messages while multiple users editing in Excel file saved in Teams

Question

We have an Excel file (.xlsx) saved in Teams. Our account is Microsoft Office 365 Pro Plus. This spreadsheet contains a list of orders we need to file freight claims on. So multiple users are adding in data throughout the day. We have 1 user who is responsible for filing claims so she stays in this spreadsheet pretty much all day to retrieve the data and add additional data. 

The 1 user who is in the spreadsheet for most of the day starting having trouble about a month and a half ago. I did some test to see what would happen. It was just her and I in the spreadsheet. 

Normally in Teams files you can see when another person is in the file at the same time. You'll see their initials on the top right and you'll also be able to see what cell they are currently in and can see them typing. I believe this is called co-authoring which is enabled by having the auto-save feature on.

1. We both have the auto-save feature on
2. She can see that I'm in the file but doesn't see what cell I'm on, nor does she see when I'm typing.
3. Even though I had the auto-save on, I clicked save after I was done typing.
4. She got this message at the top of the spreadsheet: "SAVE AGAIN We need to refresh your file with updates. Click Save to try again."
5. I typed more information and saved again.
6. She receives another message "NEW VERSION AVAILABLE Reopen to get the latest version. You won't lose any changes you've made."
7. She has to save in order for her to see the changes I made
8. I had her check her one-drive icon and it says everything is up to date.

I checked with our IT department and they are at a loss as to what could be causing this. Is there any other troubleshooting suggestions you might have?

Answer 1

Hi Jamie,

Sorry for the inconvenience caused at your end.

As per the description provided, we understand the concern facing at the user end and since you mentioned “AutoSave is turned on”, I believe you are opening the Excel file in the Excel application. Since the problem is one with specific user, please ask the problematic user to try the following and check the behavior:

a. Close the Excel files> Remove the Excel file from the Recent tab> Quit Excel application.

b. Open the File Explorer> Go to C:\Users\username\AppData\Local\Microsoft\Office\16.0\OfficeFileCache> Delete all content in that folder.

c. Re-open the Excel application> Open the problematic Excel file> Check whether file works without any problem.

If still persist, please check whether user is using the latest version of the Excel application.

Best Regards,

Chitrahaas