Forum Discussion
Shared file not updating
Hi all,
I have an excel file that is stored on teams. We have multiple users working on multiple sheets across this one file at any one time. Autosave is on when updates occur to this file. All users are accessing the file through a shortcut link on their desktop. This comes from the synced version of the sharepoint folder that contains the excel file, that is now on their file explorer tab.
I can see the changes that one group is making to one sheet on the file. Another group is updating another sheet, however no one can see their changes except locally on their computer. When you try to save and exit, it deletes all their data.
For reference, the users that are having this issue are using a generic production windows login, but their own personal windows login for teams/sharepoint to be able to access the file.
Thank you for any help. Apologies if I have been cryptic, I can't share photos due to sensitive information.
4 Replies
Hi AdamCook1996
"I can see the changes that one group is making to one sheet on the file. Another group is updating another sheet, however no one can see their changes except locally on their computer. When you try to save and exit, it deletes all their data. "Are these users using Excel Online or the Excel App? Did they turn off "Automatic saving" at the top left of their Excel App?
Best Regards,
SvenHi AdamCook1996,
you can use this troubleshooting to try resolve the issue of an Excel file not updating in Teams:
1. Check the file permissions
Make sure that all users have the necessary permissions to edit the Excel file. To do this:
- Open the Excel file in Teams.
- Click the three dots in the top right corner of the file.
- Click Manage access.
- Make sure that all users have the Can edit permission.
2. Clear the Teams cache
Clearing the Teams cache can sometimes resolve issues with file syncing. To do this:
- Close Teams.
- Press Windows key + R to open the Run dialog box.
- Type %appdata%\Microsoft\Teams in the Run dialog box and press Enter.
- Delete all of the files and folders in the Teams folder.
- Restart Teams.
3. Disable co-authoring
If you are still having problems, you can try disabling co-authoring for the Excel file. To do this:
- Open the Excel file in Teams.
- Click the three dots in the top right corner of the file.
- Click More options.
- Click Disable co-authoring.
4. Save the file to OneDrive
If you are still having problems, you can try saving the Excel file to OneDrive. To do this:
- Open the Excel file in Teams.
- Click the File tab.
- Click Save as.
- In the Save as dialog box, select OneDrive.
- Click Save.
Once the file is saved to OneDrive, all users should be able to see the changes that have been made.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
We have had these problems as well, consistently and cannot seem to get them fixed for any duration.
This is unacceptable from Microsoft. I don't do any coding any more, but from my simple experience, you just need some good data "hand shaking" to confirm the data got to where it was sent.
If there are any sort of permission issues, that should be communicated when sync was attempted, not let the user think the sync happened only later when the user looks and checks, they find out they have lost tons of data.
The instability of this situation defeats all the benefits (plus some) that the tool promises to provide.
Ken
- LeonPavesic , obviously my frustration is pointed at Microsoft (at least hope that obvious).
You obviously are a power user and know the software very well. Everyone should be grateful for this herculean solution you have provided. The issue, in my opinion, is Microsoft should not need these herculean efforts so often.
Thanks,
Ken
