Microsoft 365|Office 365

New 'Show Changes' feature Coming to Excel for the Web

One of Microsoft Excel’s Project Managers (PMs) on the Office Insider team recently published another ‘Feature deep dive‘. They announced a coming feature called Show Changes, which will allow authors more confidence when sharing and collaborating with others on Excel for the Web.

‘Show Changes’ will allow users sharing Excel files on OneDrive or SharePoint sites to view every change made to an Excel workbook over the past 60 days. You no longer have to worry about sharing your beautifully, meticulously crafted Excel spreadsheet with others, giving them edit rights. You’ll be able to review every change made with the new Changes pane on the right.

In your Excel file online, click the Review tab and click Show Changes. The Changes pane will open on the right showing you the changes to the spreadsheet with the recent changes on top.

Image #1 Expand
Image #2 Expand

The Show Changes feature enables you to collaborate confidently with others by letting you see exactly what edits were made to your workbooks in the past 60 days. You can see details about who changed what, where, and when along with the previous values of cells for quick reverting if necessary. You can filter the changes by selecting any sheet, range, or individual cell, to check all the changes at that granular level. You can even peer into when bulk edits were made across a potentially larger number of cells.

Sponsored Content

What is “Inside Microsoft Teams”?

“Inside Microsoft Teams” is a webcast series, now in Season 4 for IT pros hosted by Microsoft Product Manager, Stephen Rose. Stephen & his guests comprised of customers, partners, and real-world experts share best practices of planning, deploying, adopting, managing, and securing Teams. You can watch any episode at your convenience, find resources, blogs, reviews of accessories certified for Teams, bonus clips, and information regarding upcoming live broadcasts. Our next episode, “Polaris Inc., and Microsoft Teams- Reinventing how we work and play” will be airing on Oct. 28th from 10-11am PST.

  • Edits are showing in the Changes pane, starting with the most recent.
  • You can see who made the changes, where, and when, as well as what the edits were.
  • In cards, like the one below, which are tracking a similar change to multiple cells, you can see all the changes made at once by selecting See changes.
Image #3 Expand

You can also filter and see changes at the cell, range, or even Sheet by right-clicking it and clicking Show Changes.

Image #4 Expand

If you or others edit the workbook while the Changes pane is open, you can update the workbook with the latest changes by selecting the See new changes button.

Image #5 Expand

Microsoft will be rolling this feature out in Excel for the web for users running Targeted release builds. I would imagine we should start to see this appear later in March. This timeline is subject to change. To contribute Feedback to Microsoft once this feature is available to you, click Help -> Feedback and fill out the short form.

Related Topics:


Don't have a login but want to join the conversation? Sign up for a Petri Account

Comments (1)

One response to “New ‘Show Changes’ feature Coming to Excel for the Web”

Leave a Reply

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by: