How to Show Changes and History of Edits in Excel (Formula changes too!)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
The new Excel "SHOW CHANGES" feature lets you collaborate confidently with others! With this feature you can see the most recent data and formula changes to your Excel files for up to 60 days. It allows you to see and monitor details about who changed what, where, and when, along with the previous value of the cell for quick reversion - in case you need to.
Show-Changes is also available in the FREE version of Excel. As long as you keep your file saved on OneDrive you can monitor and track changes made by you and others you've shared the file with.
All data and formula changes are tracked even if you use Excel on Desktop, Excel on mobile or in Teams. If you open your desktop files on the web, you have the ability to view who changed your data and also to easily revert back to an older version of the file. With Version History you can restore the previous version or save a copy of the old file.
With the new Show Changes feature, you no longer need to wonder who changed your Excel spreadsheet or worry about others changing your formulas. In case you don't see the changes in the "show changes" pane, you can go to version history and you can track the changes there.
Often a lot of work goes into creating a well designed Excel spreadsheet. Therefore, when collaborating on such workbooks it’s important to understand what others are changing. With Show Changes, you get peace of mind knowing that you have a safety net and that any changes done by others are being tracked for the entire workbook down to a single cell.
***************
★ My Online Excel Courses ► www.xelplus.com/courses/
**************
More info about "Show Changes" feature: insider.office.com/en-us/blog...
What does Excel's Show Changes feature track? support.microsoft.com/en-us/o...
Link to written Article about the new Show Changes feature: www.xelplus.com/show-changes-...
LINK to more Excel 365 tutorials: • Excel for Office 365 &...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #BrandNew
Пікірлер: 147
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter Update 2022 Q3: Show Changes is now available for Excel Desktop in Office 365 (you'll find it in the Review tab).
@rubenwelten7300
Жыл бұрын
Seems like Microsoft is really working hard to improve Excel the last couple of years!
@furfmanrocks
Жыл бұрын
Do you know the version number for Update 2022 Q3?
This is so dead on realistic lol. "You like the idea of collaboration but you don't like the idea of sharing your files." Absolutely real life. Thanks Leila.
@LeilaGharani
3 жыл бұрын
😁
I love seeing show changes. It just allows me to see where I need to look for new insights. Thanks for this awesome tutorial Leila :)
My paranoid boss will have a field day with this
@LeilaGharani
3 жыл бұрын
I can relate to your boss 😁
Whenever Excel "Changes", Leila "Shows" up with a video on that feature, which is "Cool"! Enjoyed the video and this feature is sure going to be useful! Thank you! 😊👍
@LeilaGharani
3 жыл бұрын
Haha, always so creative. I wish I had that gift.
@vijayarjunwadkar
3 жыл бұрын
@@LeilaGharani Thank you! You too are a gifted trainer! 😊
@gernes91
3 жыл бұрын
Ppppppp
I am so happy that this has been added. I work with someone who loves to change things and when things go wrong say it was not them 😊
@discoanna7578
3 жыл бұрын
Sooooo know what you mean 😂
Love your videos! So helpful. Thanks!!
Very helpful, Leila. Thanks!
Beautiful video. Thanks Leila for the share.
It's very useful information. Thanks Leila.
Thank you Leila you make my job easy. You are excel life saver.
Love Your Vids. ❤️ From Canada 🇨🇦
Oh wow! That is what I needed! Thank you Leila!
@LeilaGharani
3 жыл бұрын
You're so welcome!
Amazing...great video!👌
Really good feature by microsoft AND explanation BY YOU THANKS
I always wanted to have this feature without the shared files that was old option and complex to set up. this is easy and straightforward. you are awesome Leila.. Merci :)
@LeilaGharani
3 жыл бұрын
You're welcome!
Great information, thank you. Are you planning a video (or have) on how to share documents the best way so you can track changes vs "guest" , specifically if the collaboration involves multiple partners from different organizations?
Excel continues to get better and better!
@LeilaGharani
3 жыл бұрын
So true!
Great video and really well explained. I just tried it out in an .xlsm formatted workbook but the Show Changes is grayed out. Is it not available for this excel format?
I like the Video good to know new changes.
Awesome explanation. Is there a way for all the changes to be stored on a worksheet in the workbook live?
What good timing, Leila. This/OneDrive versioning, which I had forgotten about, saved me today :-}}} Thank you!
@LeilaGharani
3 жыл бұрын
That's really a blessing and saved me MANY times :)
Thanks Leila. Amazing video as usual. However this doesn’t work for changes in a cell which takes its data from (reference) another file. Any trick to track this?
Dear Leila, Thanks a lot for your videos always clear and Helpfull. Well, I have trouble with PowerQuery on Mac. Do you know about PQ on mac ? On my mac it works, on mac of one of my friends it doesn't... We tried a lot to find solutions but no success about... If you think to have any help for me it would be greatfull ! :)
Thank you. Does it work(track) if we have used power query to populate merged data from another table. Tabs are with in same file just that the data between tabs is copied over by power query. Thanks again for this video.
Hi Leila Gharani, Thanks for this video very useful. Just a quick question. How can I track changes in Excel tables that are sourced externally. I dont think Track changes are enabled for tables sourced externally.. Look forward to your reply.
Great Leila... your Video help me alot..
@LeilaGharani
3 жыл бұрын
My pleasure 😊
Always great 👍
Wow, that's really Helpful Function. Thanks for Sharing this, Now i will be able to check who has changed the Production points and Allocation!!
@LeilaGharani
3 жыл бұрын
Exactly! No more hiding :)
Not currently available for me but can’t wait to use it in the future Thanks!
Great video as usual, I had no idea excel had this feature. Thanks 🙏🏻
@LeilaGharani
3 жыл бұрын
Happy to help!
Great content!
Excel will never obsolete 😀.... I love excel when comes to new features.
Thank you so much, your videos are very useful lessons for me 🌹
@LeilaGharani
3 жыл бұрын
Glad to hear that!
Thank you so much for sharing 😊
@LeilaGharani
3 жыл бұрын
My pleasure 😊
Hi Leila, is there a way to receive notification over email for the changes made in exel for any particular section
This is going to be very useful, thanks Leila
@LeilaGharani
3 жыл бұрын
Hope it will come in handy!
Hi, Good Day. Just wanna ask how to display the lasted saved by in a cell however, not only that, the file is not the same file where the code is written, and that the path of the file that needs to show who saved it last is supposed to be dynamic (path is a value in a specific cell)
Awesome, it will help me alot.. Thank you so much
@LeilaGharani
3 жыл бұрын
Most welcome 😊
Hi, if you possible can you explain how to store desktop application files in shared location
Thanks Leila Could I know what is your version of office 365?
Hi Leila, how do we reverse Text to Column in the same cell?
This is really helpful. I've run across version history when a sheet closed unexpectedly, but to be honest never clicked on the Info/Version History menu commands. Darn, I could have been using this all this time! Thanks Leila for opening my eyes to features of Excel I've never stumbled across.
@LeilaGharani
3 жыл бұрын
You're very welcome, Tom!
Thanks. Can you guide us how to process big data in excel.
Hi everyone! Is it possible to permanently add mid values (11.5 / 12.5 / 13.5 / and so on) in the font size, without necessarily go each time, to the option page and make changes? Thx!
Thanks
Hi there , I see your videos a lot , I have a question, I have a shared file in out property and I have a sheet protected password on this file, However there are three of us and I want to see who make changes to the file.
We use a shared file server, so using a bit of vba I prefer to use a txt file based database to act as a back end for my shared spreadsheets
Thanks you so much. You have delightful knowledge about Excel which are really important to us as on accounting field.👍👍😍😍
@LeilaGharani
3 жыл бұрын
Glad to hear that 😊
awsome
Hi, I have made a macro for copying a sheet and past it on the other sheet, I have added a timer macro which copies the sheet after every 5 minutes and past it on different sheet, when I change the timer to 1 minute instead of 5 minutes it is copying multiple times In a minute, how to avoid it please suggest. Thank you
Wow Excel is getting more and more functionalities that sometimes is hard to get track of all the new futures!! but this is good. Thanks Leiala!.
@LeilaGharani
3 жыл бұрын
You're very welcome!
How can you look up to see who’s in the file when multiple users can have access? Sometimes files can be locked for editing for hours, and I may need to make changes. Any tips is helpful, thanks!
Superb
Can you please do a video on olap tool in ms excel? Is it useful?
How long do the version history last?
Is there a formula to find the edited cel in a specific range,
This is great
Is this same for power point, I mean I uploaded my ppt and suddenly next day I see a notification this this person modified so I didn't find any changes but I'm curious to know what changes were made
Did this work for Word and Power Point aswell?
Dear Leila Gharani can you please show the other youtube on PDF to word please?? Need it..Thx
How anout Visio tips? Coming anytime soon? As engineers we work with it so much for block diagrams later embedded inyo Word and PPT, and it is so frustrating...
The tab is greyed out on one of my spreadsheets - any idea why this might be?
Is it possible to show changes with off-line version, I mean it is not on one-drive version. in case, my colleague send back the edited file. can I see what information was edit by them?
In my case when i open the file in a desk top app, the changes are missed in the online version !
How can I reach out to you for a difficult excel task guide? Its a unique thing and I haven't found anything helping for this problem
Obrigado 👏👏👏👏👏👏👏
Can I export the modification list ¿?
How do we print those changes?
Hi Leila, i have one excel sheet that 6 users on a daily basis populate and change. How to increase number of changes for that document to have history for 365 day at least?
This is a great feature. However, when I review the changes to cells, it doesn't show what the cells were changed from, it only shows what they were changed to. This video and all the articles about this new feature shows what a cell was changed from and to. Does anyone else have this issue or know how to fix it?
Good feature...
YOU are the queen of youtube
Your training sessions will help us like from beginners to advanced level 😊 Sending lots of love from India 💚💚🇮🇳
@LeilaGharani
3 жыл бұрын
Thank you!
Hi, Leila, when you restore a step, does it restore just that step or together with any steps after that? Thanks.
@LeilaGharani
3 жыл бұрын
With version history it restores to the version it was at that point in time. So all other changes made after that will be removed. You can also create a copy instead of restoring.
Wow wow wow. That is the best best tip ever.
@LeilaGharani
3 жыл бұрын
Glad you think so!
If I am creating a new Excel sheet from an old one, how can I clear all the previous track changes and start again?
How to view excel workbook 2021 created in laptop through mobile
finally..i had to write a VBA script to log timestamps and usernames to keep track and had to open up multiple files of the same file to compare them side by side for the actual content changes lol
@besilva87
3 жыл бұрын
I did the same thing. I have mine setup to log the username and timestamp on a very hidden sheet as soon as the workbook is opened, then immediately save. That way even if they don’t make any changes, I can still see who has been opening my workbooks. Call me paranoid haha, but I like to know who is going through my stuff
جالب و کاربردی
Hi Leila I am looking for a certain function in excel. I calculate the average monthly productivity of all my team members, my problem is in the table where I enter their daily production values I want to enter "A" when they are absent and "PL" when they are on a approved leave and when excel is calculating the average I want it to substitute "A" WITH 0% and "PL" with 100%. Is this possible?
@AlexisPerez1
2 жыл бұрын
This would work. In this example your data is in the F1:F20 range. =(SUM(F1:F20)+(COUNTIF(F1:F20,"PL")*100))/COUNTA(F1:F20)
Surprisingly this function is available in office 2007
how can you assign specific users only access to certain rows and columns to make changes, to prevent them from messing up your sheet??
@LeilaGharani
Жыл бұрын
Maybe this will help: kzread.info/dash/bejne/ap2Wx5RwitjMYKQ.html
problem with being a power excel user is sharing my created spreadsheets. i built a depreciation workbook that compares macrs vs gaap depreciation, fixed asset activity, for any time period. it works simply by change two input cells for starting and ending dates. that's all you have to do. sure enough, i shared it and what came back was not my spreadsheet. that automatic save feature is a bad idea.
great
Mad emoji man at :59...me when someone changes my files too...😂
@LeilaGharani
3 жыл бұрын
😁
this is going to add fun into the workplace :)..........now we know who
@LeilaGharani
3 жыл бұрын
Exactly! 😁
How NOT to present changes pane to all file users? Just available for owner of the file
(1:57) I always suspected Chris K would try something like this.
How about password protecting the workbook or parts of the workbook to prevent unwanted changes? Then there's no concern.
Wohoo. Noice 👍😊
@LeilaGharani
3 жыл бұрын
I like it too!
Don't see it under review on O365
Hi Madam, may I have your Microsoft Team Or Zoom ID. I have a excel with some data & need a report. I want to discuss/share the same withyou.
Mam do you have an email? I need help regarding my excel format im working with.. (excel 2013)
Mean while I'm over here on Excel 2019 because I'm not paying for another subscription 😅
There's a legacy track changes feature that is far superior. You don't have to save the file on SharePoint either.
I think this ends the theoretical superiority of Google Sheets in this section. This is so? Thank you Leila.
Anyone else not having this option?
A great feature that will remove some of the pitfalls of collaboratio. The downside is that getting caught pulling pranks is much higher.
👍👍