Last save date without VBA

gta1216

Board Regular
Joined
Apr 23, 2016
Messages
63
Is there anyway to insert a last save date / time without using VBA? I have a sheet that is shared on the OneDrive which would be accessed by more than 50 people. I know Excel keep track of every changes in the version history. If an not mistaken, it saves changes even when you sort the report and things like that. I want it to show the date and time when I added info to the sheet. BTW, I plan to lock the worksheet and I will be the only person who can add / modify the data, while the other people can use the filter. I may consider removing the filter function so the others can only view and copy data from the Excel file.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
If your the only person who can modify the sheet, why not just enter the date/time when you change something?
 
Upvote 0
I thought about manually entering the last update date, but I'm sure I will forget to do it every time.
 
Upvote 0
Unfortunately that is the only way I know, without using VBA
 
Upvote 0

Forum statistics

Threads
1,214,833
Messages
6,121,867
Members
449,053
Latest member
Mesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top