Select a blank cell you need to display the last saved timestamp of the workbook, enter formula =LastSavedTimeStamp() and press the Enter key, and a number will be displayed.
You are missing steps to get this command working... and even so doesn't give the information the user is asking for.
@andyj941 This information works for me:
Insert The User Name Who Modified Current Workbook Last Time With User-Defined Function
1: Hold down the
ALT +
F11 keys to open the
Microsoft Visual Basic for Applications window.
2: In the
Microsoft Visual Basic for Applications window, click
Insert >
Module, and paste the following macro in the Module Window. See screenshot:
VBA code: Insert last modified user name in Excel
1
2
3 | Function LastAuthor()
LastAuthor = ActiveWorkbook.BuiltinDocumentProperties("Last Author")
End Function |
3: Press the
Alt +
Q keys to close the
Microsoft Visual Basic for Applications window.
4. Select a cell you need to place the user name, enter formula
=LastAuthor() into the Formula Bar, and then press the
Enter key. Then the last modified user name is inserted into the cell immediately. See screenshot:
Note this can only do the last user, not the last 3 users because it seems that Excel 2010 does not have Version History like the newer versions do.
As to it being blank, was the user a local user or a network user? Is the file also in a network folder?