Reset individual changes made by others in a table?
Hi All, I have shared my table with my team who are supposed to insert data into the table.
Unfortunately, there are always some incorrect entries. I can see the changes (Before After). But can't I somehow undo this change with one click?
I would also like to know if I can prohibit certain users from deleting rows etc. or if I can only work on certain spreadsheets.
Thanks a lot
Stefan L
Answers
Top answer
Yes, it is possible to undo changes in a shared Excel spreadsheet in Microsoft Teams. Here are the steps you need to follow:
open the shared Excel spreadsheet in Microsoft Teams.
click the "History" tab at the top of the Excel toolbar.
select the cell or range you want to undo.
click the arrow next to the "Undo" button to display the list of available actions. Select the action that you want to undo.
To prohibit certain users from deleting rows or restrict them to certain spreadsheets, you can set up permissions in the Excel spreadsheet. Here are the steps you need to perform:
open the Excel spreadsheet in Microsoft Teams.
click the "File" tab at the top of the Excel toolbar.
select "Share" from the menu on the left.
select "Invite People" from the drop-down menu.
enter the email address of the user you want to grant access to.
select the desired permissions. For example, you can grant permission to edit, view, or comment.
click "Send".
You can also set more specific permissions for each user by clicking the arrow next to the permissions and selecting the permissions for each item in the table. This way you can specify who can access which spreadsheets or edit which rows.
I hope this helps
You know a better answer?
The question about Microsoft Teams has already been answered, but there may be a better solution or alternative available by now. If you know it, answer the question now and increase your reputation as an industry expert in our B2B community.