Share this article
Improve this guide
How to document and track changes in Excel on Microsoft 365
3 min. read
Published onDecember 8, 2022
published onDecember 8, 2022
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
In this article
Toggle
Many people already know how to view andTrack Changes in Word, but they might be worried that the steps will be different fromTrack Changes in Excel.
Track changes in Excel 2022
Microsoft’s previous directions on how totrack changes in a shared workbook in Excel are obsolete. Microsoft is looking to remove Track Changes tomake way for “co-authoring,”a special feature which is now available only to Microsoft 365 paid subscribers.
To co-author or track changes in Excel for Windows desktops, here are 3 things you need:
Co-author a Workbook with others
Once you have the 3 prerequisites, you probably want to know how to actually use the co-authoring feature with an Excel Workbook.
If you find that coworkers in your group can’t see any edits they made or different colors in a workbook you share with them, make sure thateveryone’sAutoSaveis turned on.
OnceAutoSaveis turned on, you will be able to co-author an Excel Workbook with others.
Follow these steps to co-author a workbook in Excel:
- Upload or create a new workbook using a web browser inOneDrive,OneDrive for Business, or aSharePoint Onlinelibrary. SharePoint On-Premises sites not hosted by Microsoft do not support co-authoring.
If you are using the Windows Desktop App, you can go toFile > Save a Copyand save a copy to a specific location on your OneDrive to track changes in Excel.
-
Click theSharebutton in the upper right corner and clickSharea second time.
-
Insert the name, group or email addresses of the people you want to share the workbook and clickSendto send an email or clickCopyto copy the link.
Summary
Reminder, Co-authoring in Excel is only available to paid subscribers,click here to try or buy Microsoft 365. Be sure to check Microsoft’s guidelines forBest Practices for Coauthoring in Excelto help you get started.
These steps will likely change as Microsoft is prepared to release anew Microsoft 365 appto replace the Office.com app installer. Be sure to check out ourdedicated Microsoft 365 news hubfor similar tips and tricks.
davew
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
davew
