Collaborate with confidence: Introducing Show Changes for Excel on the Web

Published Apr 29 2021 08:50 AM 42.6K Views
Microsoft

We’re excited to announce a new feature in Excel for the web called Show Changes.  Show Changes in Excel revolutionizes the collaboration experience for one main reason: if you pour days and detail into the perfect Excel workbook, you may hesitate before sharing editing permissions with others.  And you can’t have collaboration without sharing.  Now, with Show Changes, you have the “safety net” of knowing that any changes done by others are being tracked for the entire workbook down to a single cell.   

 

 

The Show Changes feature enables you to collaborate confidently with others by letting you see exactly what edits were made to your workbooks up to 60 days. You can see details about who changed what, where, and when, along with the previous value of the cell for quick reversion, if needed.   

 

 

So if someone accidentally overwrites your formula, you can easily catch it and fix it.  You can even see bulk edits – edits made to a whole row or range of cells at the same time – within a card in the Show Changes pane. 

 

You can also narrow down the list of changes.  If you want to see changes made JUST to a specific sheet, or range, or even an individual cell, you can select the area you want to investigate.  Then, just right-click and you’ll see the Show Changes option there.   

 

 

You can get started with Show Changes in Excel for the web today by accessing your Microsoft 365 subscription using your favorite operating system and device. With support for Windows, Mac, iPads and iPhones, and Android phones and tablets, you can be assured that all of your team's changes will be tracked. So why not take the leap and go for it? Share those workbooks and try out Show Changes in Excel for the web today.

 

Have feedback on Show Changes?  Send us a smile or frown.  Also, subscribe to our Excel Blog to get the latest product updates and announcements, and join our Excel Community to stay connected with us and other Excel fans around the world.

 

7 Comments
Occasional Visitor

Hi there, this looks really useful and another point off the list where google sheet used to be better .

I am wondering if this experience coming to Excel Desktop as well?

And will it also show structural changes? Do you have plans for "smarter" changes? E.g. when I cut and paset something it can either be shown as a deletion and an edit or as a cut/paste operaton?

 

Looking forward to seeing this feature develop in the future.

Senior Member

Is that feature supposed to be available on Excel Desktop? The article mentions support for Windows, Mac, iPads and iPhones, and Android phones and tablets. Changes made from desktop versions are tracked correctly but I only see the button to see changes on Excel Online.

Occasional Contributor

I am confused .... if this is not also in the desktop Excel how does it work if a person chooses to open and an Excel file on the desktop instead of of editing on the web? Do others see the changes done in the desktop app? Does the person in the desktop see the changes done on the web? etc etc etc?

 

 

As far as the file is kept on OneDrive/SharePoint, changes made in desktop version will visible in online version

Occasional Visitor

Hi- A few of us at my company expressed concern having this information readily accessible to just anyone. Particularly files that involve budgeting information that is shared and edited with all. We don't want some groups to be able to see the various working theories leaders have edited. At this time we're not seeing the ability to turn this feature off, clear history, or restrict who can or cannot view "Show Changes" such as the previous version (track changes) allowed.

Can you please advise or add this feature?

 

 

 

Contributor

I love this feature! Thank you for adding this feature to Excel!

Established Member

This feature is nice and useful, but it should be launched in Excel for Desktop also!!!
My company has 365 subscription which enables colleagues can co-authoring documents on the Web. However one feature is missing in the Excel for Web is "protect" and "Unprotect" the workbook and the worksheet.

 

Therefore I have another subscription to use the Excel for M365, which I can do the protect unprotect while other colleagues changing the document in Excel for Web at the same time.

 

The "Show Changes" features is great for me to track who did what, but which is only available in Excel for Web. That makes me have to switch using Excel for Web and Excel for 365 from time to time when I need to do different operation. That's so confusing and troublesome. I definitely think the "Show changes" should extend to Excel for M365.

 

P.S. The files are in SharePoint.

 

Hope this helps you understand what issue i am going through, thanks.

%3CLINGO-SUB%20id%3D%22lingo-sub-2318429%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318429%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20that%20feature%20supposed%20to%20be%20available%20on%20Excel%20Desktop%3F%20The%20article%20mentions%20support%20for%26nbsp%3B%3CSPAN%3EWindows%2C%20Mac%2C%20iPads%20and%20iPhones%2C%20and%20Android%20phones%20and%20tablets.%20Changes%20made%20from%20desktop%20versions%20are%20tracked%20correctly%26nbsp%3Bbut%20I%20only%20see%20the%20button%20to%20see%20changes%20on%20Excel%20Online.%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2370128%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2370128%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20confused%20....%20if%20this%20is%20not%20also%20in%20the%20desktop%20Excel%20how%20does%20it%20work%20if%20a%20person%20chooses%20to%20open%20and%20an%20Excel%20file%20on%20the%20desktop%20instead%20of%20of%20editing%20on%20the%20web%3F%20Do%20others%20see%20the%20changes%20done%20in%20the%20desktop%20app%3F%20Does%20the%20person%20in%20the%20desktop%20see%20the%20changes%20done%20on%20the%20web%3F%20etc%20etc%20etc%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2372506%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2372506%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20far%20as%20the%20file%20is%20kept%20on%20OneDrive%2FSharePoint%2C%20changes%20made%20in%20desktop%20version%20will%20visible%20in%20online%20version%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2384477%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2384477%22%20slang%3D%22en-US%22%3E%3CP%3EHi-%20A%20few%20of%20us%20at%20my%20company%20expressed%20concern%20having%20this%20information%20readily%20accessible%20to%20just%20anyone.%20Particularly%20files%20that%20involve%20budgeting%20information%20that%20is%20shared%20and%20edited%20with%20all.%20We%20don't%20want%20some%20groups%20to%20be%20able%20to%20see%20the%20various%20working%20theories%20leaders%20have%20edited.%20At%20this%20time%20we're%20not%20seeing%20the%20ability%20to%20turn%20this%20feature%20off%2C%20clear%20history%2C%20or%20restrict%20who%20can%20or%20cannot%20view%20%22Show%20Changes%22%20such%20as%20the%20previous%20version%20(track%20changes)%20allowed.%3C%2FP%3E%3CP%3ECan%20you%20please%20advise%20or%20add%20this%20feature%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2308302%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20this%20looks%20really%20useful%20and%20another%20point%20off%20the%20list%20where%20google%20sheet%20used%20to%20be%20better%20.%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20this%20experience%20coming%20to%20Excel%20Desktop%20as%20well%3F%3C%2FP%3E%3CP%3EAnd%20will%20it%20also%20show%20structural%20changes%3F%20Do%20you%20have%20plans%20for%20%22smarter%22%20changes%3F%20E.g.%20when%20I%20cut%20and%20paset%20something%20it%20can%20either%20be%20shown%20as%20a%20deletion%20and%20an%20edit%20or%20as%20a%20cut%2Fpaste%20operaton%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20forward%20to%20seeing%20this%20feature%20develop%20in%20the%20future.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2444796%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444796%22%20slang%3D%22en-US%22%3E%3CP%3EI%20love%20this%20feature!%20Thank%20you%20for%20adding%20this%20feature%20to%20Excel!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279187%22%20slang%3D%22en-US%22%3ECollaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279187%22%20slang%3D%22en-US%22%3E%3CP%3EWe%E2%80%99re%20excited%20to%20announce%20a%20new%20feature%20in%20Excel%20for%20the%20web%26nbsp%3Bcalled%26nbsp%3BShow%20Changes.%26nbsp%3B%26nbsp%3BShow%20Changes%20in%20Excel%20revolutionizes%20the%20collaboration%20experience%20for%20one%20main%20reason%3A%20if%20you%20pour%20days%20and%20detail%20into%20the%20perfect%20Excel%20workbook%2C%20you%20may%20hesitate%20before%20sharing%20editing%20permissions%20with%20others.%26nbsp%3B%26nbsp%3BAnd%20you%20can%E2%80%99t%20have%20collaboration%20without%20sharing.%26nbsp%3B%26nbsp%3BNow%2C%20with%20Show%20Changes%2C%20you%20have%20the%20%E2%80%9Csafety%20net%E2%80%9D%20of%20knowing%20that%20any%20changes%26nbsp%3Bdone%26nbsp%3Bby%20others%20are%20being%20tracked%20for%20the%20entire%20workbook%20down%20to%20a%20single%20cell.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%26nbsp%3BShow%20Changes%26nbsp%3Bfeature%26nbsp%3Benables%20you%20to%20collaborate%20confidently%20with%20others%26nbsp%3Bby%20letting%26nbsp%3Byou%20see%20exactly%20what%20edits%20were%20made%20to%20your%26nbsp%3Bworkbooks%26nbsp%3Bup%20to%26nbsp%3B60%20days.%20You%20can%20see%20details%26nbsp%3Babout%26nbsp%3Bwho%20changed%20what%2C%20where%2C%20and%20when%2C%20along%20with%20the%20previous%20value%20of%20the%20cell%20for%20quick%20reversion%2C%20if%20needed.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%26nbsp%3Bif%20someone%20accidentally%20overwrites%26nbsp%3Byour%26nbsp%3Bformula%2C%20you%20can%20easily%20catch%20it%20and%20fix%20it.%26nbsp%3B%20You%20can%20even%20see%20bulk%20edits%20%E2%80%93%20edits%20made%20to%20a%20whole%20row%20or%20range%20of%20cells%20at%20the%20same%20time%20%E2%80%93%20within%20a%20card%20in%20the%20Show%20Changes%20pane.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%26nbsp%3Balso%26nbsp%3Bnarrow%20down%20the%20list%20of%20changes.%26nbsp%3B%26nbsp%3BIf%20you%20want%20to%20see%20changes%20made%20JUST%20to%20a%20specific%26nbsp%3Bsheet%2C%26nbsp%3Bor%26nbsp%3Brange%2C%20or%26nbsp%3Beven%20an%26nbsp%3Bindividual%20cell%2C%26nbsp%3Byou%20can%20select%20the%20area%20you%20want%20to%20investigate.%26nbsp%3B%26nbsp%3BThen%2C%20just%20right-click%20and%20you%E2%80%99ll%20see%20the%20Show%20Changes%20option%20there.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20get%20started%20with%20Show%20Changes%20in%20Excel%20for%20the%20web%20today%20by%20accessing%20your%20Microsoft%20365%20subscription%20using%20your%20favorite%20operating%20system%20and%20device.%20With%20support%20for%20Windows%2C%20Mac%2C%20iPads%20and%20iPhones%2C%20and%20Android%20phones%20and%20tablets%2C%20you%20can%20be%20assured%20that%26nbsp%3Ball%20of%26nbsp%3Byour%20team's%20changes%20will%20be%20tracked.%20So%20why%20not%20take%20the%20leap%20and%20go%20for%20it%3F%20Share%20those%20workbooks%20and%20try%20out%20Show%20Changes%20in%20Excel%20for%20the%20web%20today.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20feedback%20on%20Show%20Changes%3F%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3ESend%20us%20a%20smile%20or%20frown%3C%2FA%3E.%26nbsp%3B%20Also%2C%20subscribe%20to%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%20Blog%3C%2FA%3E%26nbsp%3Bto%20get%20the%20latest%20product%20updates%20and%20announcements%2C%20and%20join%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%20Community%3C%2FA%3E%26nbsp%3Bto%20stay%20connected%20with%20us%20and%20other%20Excel%20fans%20around%20the%20world.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2279187%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3EShow%20Changes%20revolutionizes%20the%20collaboration%20experience%20in%20Excel%20for%20the%20web%2C%20tracking%20edits%20at%20the%20cell%20level.%20%26nbsp%3B%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2840693%22%20slang%3D%22en-US%22%3ERe%3A%20Collaborate%20with%20confidence%3A%20Introducing%20Show%20Changes%20for%20Excel%20on%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2840693%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20feature%20is%20nice%20and%20useful%2C%20but%20it%20should%20be%20launched%20in%20Excel%20for%20Desktop%20also!!!%3CBR%20%2F%3EMy%20company%20has%20365%20subscription%20which%20enables%20colleagues%20can%20co-authoring%20documents%20on%20the%20Web.%20However%20one%20feature%20is%20missing%20in%20the%20Excel%20for%20Web%20is%20%22protect%22%20and%20%22Unprotect%22%20the%20workbook%20and%20the%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%20I%20have%20another%20subscription%20to%20use%20the%20Excel%20for%20M365%2C%20which%20I%20can%20do%20the%20protect%20unprotect%20while%20other%20colleagues%20changing%20the%20document%20in%20Excel%20for%20Web%20at%20the%20same%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%22Show%20Changes%22%20features%20is%20great%20for%20me%20to%20track%20who%20did%20what%2C%20but%20which%20is%20only%20available%20in%20Excel%20for%20Web.%20That%20makes%20me%20have%20to%20switch%20using%20Excel%20for%20Web%20and%20Excel%20for%20365%20from%20time%20to%20time%20when%20I%20need%20to%20do%20different%20operation.%20That's%20so%20confusing%20and%20troublesome.%20I%20definitely%20think%20the%20%22Show%20changes%22%20should%20extend%20to%20Excel%20for%20M365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20The%20files%20are%20in%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%20you%20understand%20what%20issue%20i%20am%20going%20through%2C%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Apr 28 2021 09:31 AM
Updated by: