“What type of changes are tracked?”
All changes to values in cells or changes to formulas are tracked.
Formatting and functional changes to charts are not tracked.
See the following link for a comprehensive list of which items are tracked.
<<<< LINK GOES HERE >>>>
“Is this available in the free version of Excel?”
YES! If you have a personal Microsoft account you can share your Excel file with others. Provided you have your file saved on your OneDrive account, the changes will be tracked.
“Are my changes tracked when I use Excel for Desktop?”
YES! Changes are tracked regardless of the endpoint used.
You can be editing your document in Teams, on your mobile device, on your Desktop; they’re all being tracked provided the file is stored in your OneDrive account or a SharePoint site.
“Can I use Show Changes on the Desktop version of Excel?”
Sadly, no. The feature is only available when opening the file in the online version of Excel.
But let’s be optimistic and hope we see this feature appear in the Desktop version of Excel soon.
“How far back in time does the Version History track changes?”
According to Microsoft, changes are tracked for up to 60 days. This can be less depending on the volume of information that has changed.
In case you don’t see your changes in this list, open the Version History panel from the File -> Info option discussed earlier.