Last update date in excel

You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished. Works great. Thanks very much for posting this. The code works great, thank you However, is there a way to get it to update automatically update each time I save After I save, I have to go into the formula within the cell, click enter to get it to reflect the new save timestamp.

Thanks for the article. Worked perfect to me. Because of the title I thought I was getting a date stamp for the worksheet, but after getting it to work was disappointed to see that it's actually for the workbook and not at all what I wanted. Rather a waste of my time from your inaccuracy! Dear MJR, Sorry for the inconvenience my mistake has caused you. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

Details required : characters remaining Cancel Submit 2 people found this reply helpful. I am a Mac User.

I am looking on the functions list but I can't seem to locate or guess what this might be. I only want this date to change when the file is saved or updated. Can you help - it seems like such a simple thing but I am stumped. Regards Jo. This thread is locked. Write Effective Editorial. Record Prepaid Expenses. Track Incidents. Manage Leaves. Measure Sales Objectives. Project Portfolio Follow-up. Recruitment Follow-up. Customer Stories. Toggle Navigation Features Pricing Customers.

VBA code: Insert last modified date in header or footer. And you can see the last modified date and time has been inserted into the center header. See screenshots:. The last modified date and time is updated automatically, when you modify and save the Excel file.

With Kutools for Excel, you can uset the Insert Workbook Information tool to quickly insert the workbook information to header, footer, or a cell. Related article:. Get and insert the created time and last modified time in cells. Note: The other languages of the website are Google-translated. Back to English. Log in.

Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you.