How to Display the Last Updated Date of a Source File onto a Shared File

Question

On our company SharePoint site I maintain a master excel file/table of all employee training completions, which only I have access to. Occasionally I import new completions from a training website. Basically, I just copy/paste new rows of completions into the master file.

That master file is connected to (supplies the data for) a different sheet on SharePoint which our employees have access to and I use power query editor to show only what is relevant. On the file that employees have access to, how do I add a 'last updated' feature so that employees know if/when I've last updated the master/source file? I may only update the master file once a month, and I'd like them to see a cell that shows when the master file was last updated.

Thanks for any help you could provide.

Answer 1

Dear David Hudacek

Good day! Thank you for posting to Microsoft Community. We are happy to help you

To display the last updated date of the source file onto the shared file, you can follow these steps:

1. Open the shared file in Excel.
2. Select the cell where you want to display the last updated date.
3. In the formula bar, type the following formula: =FileDateTime("path\filename.xlsx")
4. Replace "path\filename.xlsx" with the path and name of your master file.
5. Press Enter to apply the formula.
6. The cell will now display the last modified date and time of the master file.

Note: The formula will only update when the shared file is opened, so it may not reflect the most recent update if the shared file has not been opened since the master file was last updated.

Thanks for your cooperation.

Sincerely,

Tin | Microsoft Community Moderator

Answer 2

Hello Tin,

Thanks for your reply.

That seems easy enough, however I'm not exactly sure of the best method to obtain the file path. And the cell is showing #NAME?, see attachment. Or do I not include the open/close quotes or parentheses?

Thank you,

Answer 3

Dear David Hudacek,

Good day! Thank you for posting to Microsoft Community. We are happy to help you

I am sorry that I did not specify clearly, this formula is mainly used for VBA writing, you can refer to the following documents：

FileDateTime function (Visual Basic for Applications) | Microsoft Learn

Thanks for your cooperation.

Sincerely,

Tin | Microsoft Community Moderator