

You want to display the name of the author or who has saved the Excel file the last time? Or you want to insert the date last saved, the date created or the file size into an Excel cell? Unfortunately, there is no way without some disadvantages. Let’s take a look at three different methods.
Contents
I know, it sounds stupid, but often doing it manually is the fastest way and doesn’t come with some of the disadvantages of the next two methods. Just type the current date or your name into the dedicated Excel cell.
In case you want to show the current time you could also use a keyboard shortcut. Press Ctrl + Semi-colon (;) on the keyboard and Excel will write the current date into the currently selected Excel cell.
Because there is no automatic built-in way to return some of the meta data of your file in an Excel cell, you need to use a VBA macro. Therefore, you have to insert a new VBA module to your workbook. If you need assistance with the, please refer to this article. Once you have a new Excel module, simply copy and paste one of the following code snippets into this module. As you have done all the preparations now you can use the corresponding Excel formula in your worksheet.
Steps for using the VBA macros below.
Example: Insert the date last saved into an Excel cell.
Function ProfessorExcelLastSaveDate() ProfessorExcelLastSaveDate = FileDateTime(ActiveWorkbook.FullName) End Function
=ProfessorExcelLastSaveDate()
Please note: In order to show correct values for some of the formulas, you have to save your workbook first.
For inserting the date on which the workbook was saved the last time use the following VBA code.
Function ProfessorExcelLastSaveDate() ProfessorExcelLastSaveDate = FileDateTime(ActiveWorkbook.FullName) End Function
In your Excel worksheet, insert this following formula.
=ProfessorExcelLastSaveDate()
VBA macro code for inserting the date the workbook was created.
Function ProfessorExcelDateCreated() ProfessorExcelDateCreated = ThisWorkbook.BuiltinDocumentProperties("Creation date") End Function
In your Excel worksheet, insert this following formula.
=ProfessorExcelLastSaveDate()
VBA macro code for inserting the name of the person who saved the workbook the last time.
Function ProfessorExcelLastSavedBy() ProfessorExcelLastSavedBy = ThisWorkbook.BuiltinDocumentProperties("Last Author") End Function
In your Excel worksheet, insert this following formula.
=ProfessorExcelLastSavedBy()
VBA macro code for inserting the author name of your Excel workbook.
Function ProfessorExcelAuthor() ProfessorExcelAuthor = ThisWorkbook.BuiltinDocumentProperties("Author") End Function
In your Excel worksheet, insert this following formula.
=ProfessorExcelAuthor()
VBA macro code for inserting the file size of your Excel workbook.
Function ProfessorExcelFileSize() ProfessorExcelFileSize = FileLen(ThisWorkbook.FullName) End Function
In your Excel worksheet, insert this following formula.
=ProfessorExcelFileSize()
Just type one of the Professor Excel for the author name, date last saved etc. into an Excel cell.
Are you looking for a more comfortable way? A method, in which you don’t have to use a VBA macro? The Excel add-in “Professor Excel Tools” offers exactly that.
What do you have to do? Just download the add-in (click here). Don’t worry, the integrated formulas also work after the trial period is over. Then type one of the following formulas in your Excel cell.
Professor Excel Tools also provides a formula creator that helps you inserting the special formulas.
The formula looks like this: =PROFEXDateLastSaved(A1) . Instead of referring to cell A1 in this formula, you can also link to another worksheet or another workbook.
The formula looks like this: =PROFEXDateCreated(A1) . Instead of referring to cell A1 in this formula, you can also link to another worksheet or another workbook.
The formula looks like this: =PROFEXLastSavedBy(A1) . Instead of referring to cell A1 in this formula, you can also link to another worksheet or another workbook.
The formula looks like this: =PROFEXAuthor(A1) . Instead of referring to cell A1 in this formula, you can also link to another worksheet or another workbook.
The formula looks like this: =PROFEXFileSize(A1) . Instead of referring to cell A1 in this formula, you can also link to another worksheet or another workbook.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
Download all examples above in this workbook.
Please feel free to download all examples above in one Excel workbook. Just click on this link and the download starts right away.
Was the information helpful in this article?
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Subscribe to our popular Excel newsletter! You get all this:
Your welcome gift: Our big 45 pages keyboard shortcuts package.
Subscribe now! In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Please use this download link to download the Currency Converter Excel add-in!
Please use this download link to download the comment extraction example: http://bit.ly/Extract_Comment_Example
Comments 1
Jenn
Hello,
What if I needed last save on multiple worksheets within a workbook?
I have a workbook that houses several worksheets and several people can revise data. How can I determine the last time a specific sheet was updated?