Microsoft Excel Tutorial
Someone deleted some cells in Excel Online.
Using the Version History, it happened between 11:01 and 11:07 AM.
But Show Changes is not showing who changed it?
How could this be happening?
One way is to overwhelm Show Changes by making 3000 changes with VBA.
Another way might be changes by Power Automate Flows.
Do you have another way?
Someone deleted some cells in Excel Online.
Using the Version History, it happened between 11:01 and 11:07 AM.
But Show Changes is not showing who changed it?
How could this be happening?
One way is to overwhelm Show Changes by making 3000 changes with VBA.
Another way might be changes by Power Automate Flows.
Do you have another way?
Transcript of the video:
Oh, I've got a mystery for you.
Cell was deleted but not logged in show changes.
Great comment from YouTube.
Someone says I'm trying to track down who deleted info. I can find it in the previous versions and it had to be one of five people between 11:06 and 11:15 AM but we don't know who.
It just shows it's gone and not who was there and it's not in show changes.
What's up with this?
All right, so here's my workbook that I use for show changes.
This is of course to save to OneDrive.
I am back here on the review tab, we can bring up the show changes panel and it does a good job of showing any changes I would make.
So if I'd come here and change, Cell B4 to 123, press enter, see new changes, and I can see that I changed from 333 to 123.
It would even show if I had done something a little bit not ethical.
So here's my record.
If I came here, this is my commission and if I just juiced it from 500 to 5,000, they are going to show that I changed the formula from this to this.
All right, so what was deleted, I wonder?
All right, and if we delete something, so here they're saying that everyone has to work half a day on Saturday and of course, we're not getting paid for it.
So I delete that and that shows up in show changes.
All right, if something external to Excel changes the workbook, for example, maybe there was a Power Automate Flow that changed it.
Or let's switch over into VBA here.
Here's a macro that first clears the last phrase that says we have to work on Saturday and then about a thousand times it will write a random number two, a cell, change that formula to a value, and then at the end clear it.
All right?
And I'll do Alt F8, make some changes with the BBA click run.
You can see up here the numbers are changing rapidly.
At the end, I've cleared that I had done anything to that cell and you see that what used to be in A17 is now gone.
Turn on show changes, all right and it shows a lot of edits to that cell K3 that I was changing.
But if I need to see who deleted this, right-click show changes.
These are the recent changes.
See it, I've overwhelmed the system, it's gone.
And even show more changes is not bringing anything back.
Here this commission.
Has anyone changed any commission cells?
Right-click show changes and it's gone.
Well, so that's kind of worrisome, right?
Someone who is a bad actor, who is intentionally trying to cover their tracks by just making a lot of changes with VBA, is able to wipe out the show changes and essentially cover their tracks.
Now, it's hard to say, is that what happened in this case?
I don't know if you've had this happen to you where show changes isn't showing a change that you think should show up, let me know down in the YouTube comments.
It'll be interesting to have this conversation with the folks at Microsoft who handle show changes.
Many thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
If you like these videos, please down below, like, subscribe, and ring the bell.
Feel free to post any questions or comments down in the comments below.
Cell was deleted but not logged in show changes.
Great comment from YouTube.
Someone says I'm trying to track down who deleted info. I can find it in the previous versions and it had to be one of five people between 11:06 and 11:15 AM but we don't know who.
It just shows it's gone and not who was there and it's not in show changes.
What's up with this?
All right, so here's my workbook that I use for show changes.
This is of course to save to OneDrive.
I am back here on the review tab, we can bring up the show changes panel and it does a good job of showing any changes I would make.
So if I'd come here and change, Cell B4 to 123, press enter, see new changes, and I can see that I changed from 333 to 123.
It would even show if I had done something a little bit not ethical.
So here's my record.
If I came here, this is my commission and if I just juiced it from 500 to 5,000, they are going to show that I changed the formula from this to this.
All right, so what was deleted, I wonder?
All right, and if we delete something, so here they're saying that everyone has to work half a day on Saturday and of course, we're not getting paid for it.
So I delete that and that shows up in show changes.
All right, if something external to Excel changes the workbook, for example, maybe there was a Power Automate Flow that changed it.
Or let's switch over into VBA here.
Here's a macro that first clears the last phrase that says we have to work on Saturday and then about a thousand times it will write a random number two, a cell, change that formula to a value, and then at the end clear it.
All right?
And I'll do Alt F8, make some changes with the BBA click run.
You can see up here the numbers are changing rapidly.
At the end, I've cleared that I had done anything to that cell and you see that what used to be in A17 is now gone.
Turn on show changes, all right and it shows a lot of edits to that cell K3 that I was changing.
But if I need to see who deleted this, right-click show changes.
These are the recent changes.
See it, I've overwhelmed the system, it's gone.
And even show more changes is not bringing anything back.
Here this commission.
Has anyone changed any commission cells?
Right-click show changes and it's gone.
Well, so that's kind of worrisome, right?
Someone who is a bad actor, who is intentionally trying to cover their tracks by just making a lot of changes with VBA, is able to wipe out the show changes and essentially cover their tracks.
Now, it's hard to say, is that what happened in this case?
I don't know if you've had this happen to you where show changes isn't showing a change that you think should show up, let me know down in the YouTube comments.
It'll be interesting to have this conversation with the folks at Microsoft who handle show changes.
Many thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
If you like these videos, please down below, like, subscribe, and ring the bell.
Feel free to post any questions or comments down in the comments below.
