Forum Discussion
Solved
Track changes in a Excel file which is stored in Teams
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 possi...
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
I have found a perfect solution right now.
We need to use Microsoft Edge for that. We regularly paste links for meetings and attendance on Excel Sheets. We work in school and sometime someone deletes the link by mistake on the sheet or misplaces the data somewhere. We were worried about w(ho was doing that and needed to track the person.
First of, open your Teams in Microsoft Edge. Open your excel sheet in that. One the right top corner, there are three dots (Ellipses) click on them. This will show you an Excel Icon that says "Open in Browser". You click on that. a new but similar sheet will open up. The Theme of this sheet will now be Green color. If you look at the left side, just below your search bar, it will say the name of your file and in front of it will be the word "saved" and a tiny arrow pointing downwards. When you click on that tiny arrow it will be a small drop down menu, that also say "Version History" and the Bobs your uncle. On the right side the browser will show all of the changes and modifications with names, date, time and type. I hope it solves your problem.
We need to use Microsoft Edge for that. We regularly paste links for meetings and attendance on Excel Sheets. We work in school and sometime someone deletes the link by mistake on the sheet or misplaces the data somewhere. We were worried about w(ho was doing that and needed to track the person.
First of, open your Teams in Microsoft Edge. Open your excel sheet in that. One the right top corner, there are three dots (Ellipses) click on them. This will show you an Excel Icon that says "Open in Browser". You click on that. a new but similar sheet will open up. The Theme of this sheet will now be Green color. If you look at the left side, just below your search bar, it will say the name of your file and in front of it will be the word "saved" and a tiny arrow pointing downwards. When you click on that tiny arrow it will be a small drop down menu, that also say "Version History" and the Bobs your uncle. On the right side the browser will show all of the changes and modifications with names, date, time and type. I hope it solves your problem.
Fiza_Hayat An even easier option though to see Version History as you suggest, is to simply click File > Info > Version History - there is no longer a need to 'View in Browser' when a file is open in Teams.
Hope this helps.
