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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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,893
Messages
6,122,121
Members
449,066
Latest member
Andyg666

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