SOLVED

Track changes in a Excel file which is stored in Teams

Occasional Visitor

Hi all,

I have the following task:

We have an excel file in MS Teams. We want to work together on that and want to be able to track exactly who has changed something in which cell. Is there a possibility in MS Teams to do that? The change history of the file in MS SharePoint is not sufficient in this particular case.

 

Many thanks in advance for all your answers and best wishes

Jonas

3 Replies
best response confirmed by ThereseSolimeno (Microsoft)
Solution

Hi @Jonas_JonesB ,

 

All files that you see in Teams are stored in SharePoint, you are just seeing a view of a folder within the underlying SharePoint site.  

 

If the functionality in SharePoint is not sufficient I am afraid that is all that is available. 

 

Andy Hodges | ThinkShare | www.thinkshare.uk

Microsoft used to have the feature to Track Changes in Excel, but they deprecated it. You can still add it back to the Ribbon by going to Excel options, but this may limit how it can be shared (e.g. you might not be able to share it via OneDrive anymore).

This is a useful feature, so naturally Microsoft has removed it only to re-announce that it's a "new" feature landing soon in Excel. This new feature does the exact same thing as the old feature, so let's hope it stays around... it should roll out to all tenants over the next several months.

See more here: https://insider.office.com/en-us/blog/collaborate-with-confidence-with-show-changes-in-excel-web
I was using an excel file today via teams and co-authoring and I was asked if I wanted to see the changes made. So this is in our tenant and may be in yours now or soon.