Displaying Last Modification Time in Excel

Excel
22
min read

Ever wondered how to insert dates in Excel, specifically to track the last modification date in your cells? Keeping track of the last modified date in Excel can simplify your work and help you stay organized. Imagine you maintain an employee directory—people get hired, transfer to different branches, and so on. You use Excel to centralize all this information, including hiring dates, positions, office locations, and more.

Now, if someone modifies the file online, but your Employee Directory doesn't show the last modification time, it becomes challenging to identify which version of your printed files is the most up-to-date. Displaying the last time your file was modified will make your work much easier.

In this article, we'll explore two options:

  1. Delve into how to display the creation time and last modification time in Excel (it’s a bit advanced and somewhat disappointing at the same time).
  2. Discover how RowShare, an Excel-integrated alternative, can accomplish this with just a few clicks, offering a more efficient solution.

Getting the last modification date in Excel

If you simply want to see the creation time and last modification time of your Excel file, it's quite simple:

  1. Click on “File
  2. Select “Info
  3. Find the information you need under the “Related Dates” section

Unfortunately, this date is not available in the spreadsheet itself, but only in this settings page. If you want to have it displayed in the spreadsheet itself, you need to revert to an Excel VBA function. It's easy if you're already into programming:

  1. In your Excel worksheet, cllick on ALT + F11 to open the Visual Basic editor
  2. In Visual Basic Editor, click on the “Insert” menu
  3. Select “Module”
  4. Paste the following code into the new module:Public Function ModDate()
    ModDate = Format(FileDateTime(ThisWorkbook.FullName), “m/d/yy h:n ampm”)
    End Function
  5. Before saving your module, make sure to save your Excel file as Excel Macro-Enabled Workbook
  6. Save your module
  7. Return to your Excel worksheet
  8. Paste the following code into the cell where you want to display the last modification time:  =ModDate()

In this example, the code is pasted in cell A2.

It doesn’t update automatically. You must close your file and reopen it to have the last update time.

And unfortunately, it is still the file-level modification time, and not the row-level modification time.

If you truly need to track when rows are added or modified in your tables, it might be worth considering alternatives to Excel. This doesn’t mean you should stop using Excel altogether, but for specific tasks like tracking modification dates, other applications may be much better suited to the job. Let's have a quick look at RowShare.

Display Created Time and Last Modified Time in RowShare

Now, let’s explore another solution: an online collaboration tool that integrates seamlessly with Excel to boost your efficiency. With RowShare’s “Creation Date” and “Last Write Date” column types, you can easily keep track of when an entry was created and when it was last updated. Simply follow these steps:

  1. Create a table from a template or start from a blank page.
  2. Add a “Creation Date” column and/or a “Last Write Date” column.

That’s really all, it’s as simple as that! Each row now has this information always up to date, in these new columns.

Here is a quick video tutorial:

As you can see, whenever a row is modified, the last write date of that row is updated.

RowShare can also send notification upon updates, send reminder to anyone who is late updating his data...

Don’t just take my word for it, go ahead and give it a try yourself!

Published on  
2018-01-10

From the blog

View all the posts
right arrow
A Wealth of New Features for RowShare's Fall Release
Our team is spoiling you for this 2024 back-to-school season. Here's a preview of the new features arriving this Monday, September 30th
News
Read article
right arrow
Welcome to the New RowShare Website!
As part of our ongoing commitment to improving your experience, we've given our online home a fresh look and feel. We understand that change can sometimes be a bit disorienting, so we wanted to take a moment to guide you through what's new and reassure you about what hasn't changed.
News
Read article
right arrow
How to insert attachments in Excel
Do you ever need to insert files into Excel to share more detailed information with your co-workers? Whether it's inserting PDFs or Word documents, it seems simple enough: just click on Insert, Text, Object, choose your file, and voilà! But then what? Your file ends up floating around your spreadsheet, not anchored to a specific cell. To sort or move it along with the rest of your data, what you really need is to place it within a single cell. So, how can you do this? Not to mention the exponentional size of your spreadsheet.
Excel
Read article
right arrow
Sharing Excel rows with different people. Is it really that easy?
Do you sometimes wonder how to share a Microsoft Excel file with different people without letting everyone see all the data? Maybe each row in your Excel file contains sensitive information, and you want each person to see only the rows that concern them.Imagine you're a teacher recording student grades in Excel, with the students' grades listed in a column. You don’t want each student to see the grades of others, so you need to share your Excel file in a way that allows each student to view only their own grade (their own row). In this scenario, each row must correspond to a single student.
Excel
Read article
right arrow