Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

ways to have "Last saved" for files that change in file name?

0

Hi, I have an extensive excel file that I rename the file each time I make edits but I would also like a cell on the summary paget that shows when it was last saved for others that are viewing the same document.  They would open the lastest dated file but this way it's also incase I forget to update the date on the most recent version. Thank you!!

I have learned a lot from your videos and much appreciate all the help!

Best,
Yoon

Answer
Discuss

Answers

0

The information you want is shown in the document properties (File > Properties in earlier versions of Excel / Info > Properties in Excel 365). There you will find the dates "Created" and "Last modified". You can also access the properties by right-clicking on a file name in Windows Explorer. In fact, in that presentation you get more information, such as who created or last modified the file.

The Created date is the date (and time) when the file was created. In your system that would be when the copy was made but not when you first started the file. The Last Modified date (and time) is any time after the creation when a change was made and the file saved. I find that the properties don't fully replace a system of renaming files with a date. Therefore I still rename my own files with a date. But as a backup as you wish for this should work perfectly.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login