HomeApplicationOffice information

How to automatically update the Excel file editing time

If working in a team when processing Excel documents, the content of the file will be edited many times, with different times. To control and manage the contents of an Excel file or to know when the other person last edited the file, you can insert the automatic update time into Excel. Then information about the time of creating, editing the latest Excel file is recorded and displayed right in the Excel file, helping you to know the last date the content was changed. The following article will guide you how to update the last time you edited an Excel file.

Instructions for updating the Excel file editing time

Step 1:

First of all we open the Excel file we want to add the edited time to the content. Press the key combination Alt + F11 to open the VBA code editor.

At Microsoft Visual Basic for Applications interface, click Insert and then select Module as shown below.

How to automatically update the Excel file editing time Picture 1

Step 2:

Then you enter the following code into the interface.

 Sub Workbook_Open() Range("A21").Value = Format(ThisWorkbook.BuiltinDocumentProperties("Creation Date"), "short date") Range("B21").Value = Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), "short date") End Sub

Note A1 and B1 are the position of the two cells where the creation time and the last time Excel file was modified. This position can vary depending on where the user sets the time in the Excel data table.

Once you have entered the code, click the Run icon to run.

How to automatically update the Excel file editing time Picture 2

Finally, at the position of the 2 cells you selected will display the time of the Excel file created and the time to edit the Excel file. Time display can completely change the format if desired.

How to automatically update the Excel file editing time Picture 3

See more:

  1. Instructions on how to insert current date in Excel
  2. How to format dates in Excel
  3. How to insert the current time into Google Sheets

I wish you successful implementation!

4 ★ | 5 Vote
time function in excel

You should read it

May be interested

  • Date functions in Excel, DAY, WEEKDAY, MONTHDate functions in Excel, DAY, WEEKDAY, MONTH
    do you want to automatically update the current date, separate years or calculate the distance between two time points? the article below, free download will guide you how to do this professionally with date functions in excel.
  • How to Open Password-Protected Excel FilesHow to Open Password-Protected Excel Files
    this article explains how to remove the password of a protected excel worksheet and how to crack the password of an encrypted excel file. in most cases, removing the password of a worksheet that is locked from editing in an excel file is quick and simple! however, if you need a password to open the file, the operation will be more complicated. there is no official way to decrypt excel files without using a password cracking program - often a resource-intensive process depending on the complexity of the password. you should still try it though!
  • How to fix Vietnamese error when opening CSV file in ExcelHow to fix Vietnamese error when opening CSV file in Excel
    when converting excel file data into a csv file, you often encounter errors that do not display vietnamese fonts. this will undoubtedly have a small impact on your work. so how to fix the excel file error when converting to csv.
  • 5 nightmares for Excel and how to fix it5 nightmares for Excel and how to fix it
    we will show you how to handle multiple workbooks effectively, speed up heavy files, track changes from multiple users, find the required features in a multitude of ribbons and import data one by one. easy way.
  • How to Automatically Report on ExcelHow to Automatically Report on Excel
    today's tipsmake will guide you how to automatically report data on microsoft excel. this article also talks about how to query and create reports from external sources (mysql, postgres, oracle, etc.) right on your spreadsheet using the excel plug-in to link your spreadsheet to the source. that data. as for data stored on excel spreadsheets, we will use macro commands to create and export reports into many different file types with just one keystroke. luckily, excel has this feature built in, so you won't need to create your own algorithm.
  • Instructions to fix computer errors that do not automatically update date and timeInstructions to fix computer errors that do not automatically update date and time
    do you need to fix the error of your computer not automatically updating the date and time? then you've come to the right place because tipsmake has a solution to help you fix it
  • How to set Excel password to secure data fileHow to set Excel password to secure data file
    setting up excel password has many ways, from simple to use excel's built-in password feature to use vba. below tipsmake.com will show you the most basic ways to protect your excel file.
  • Instructions for inserting a PDF file into Excel spreadsheetInstructions for inserting a PDF file into Excel spreadsheet
    if you're having trouble inserting a pdf file into an excel spreadsheet and you don't know how to do it. inserting pdf files into excel spreadsheets is not as simple as you think. in the article below, network administrator will guide you through the steps to insert a pdf file into excel spreadsheet.
  • Time settings are automatically saved in ExcelTime settings are automatically saved in Excel
    auto-save time settings in excel - in excel, the default auto-save time is 10 minutes, but you can change the auto-save time to suit your needs.
  • How to turn off Update Link notification in ExcelHow to turn off Update Link notification in Excel
    when an excel file comes from a variety of sources, you will often find the message to request a link update quite annoying.

Office information