Last save date without VBA

gta1216

Board Regular
Joined
Apr 23, 2016
Messages
59
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.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,797
Office Version
  1. 365
Platform
  1. Windows
If your the only person who can modify the sheet, why not just enter the date/time when you change something?
 

gta1216

Board Regular
Joined
Apr 23, 2016
Messages
59
I thought about manually entering the last update date, but I'm sure I will forget to do it every time.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,797
Office Version
  1. 365
Platform
  1. Windows
Unfortunately that is the only way I know, without using VBA
 

Watch MrExcel Video

Forum statistics

Threads
1,118,609
Messages
5,573,207
Members
412,514
Latest member
LangdonJohn
Top