How to Tell When an Excel Workbook Was Last Updated

Image courtesy of Microsoft Office online

Microsoft Excel is a powerful and useful spreadsheet program. It is used primarily for financial operations. If the spreadsheet is updated often and there is a question about the last update, this information can be located in Excel. Here's how to tell when an Excel workbook was last updated.

Instructions

1. 

   Open Microsoft Excel by going to "Start," "Programs," "Microsoft Office" and "Microsoft Excel" or "Start" and then "Microsoft Excel."

2. 

   Open an existing spreadsheet by clicking on the Office icon and navigating to the file you want to open or go to "File" and "Open."

3. 

   Click on the Office icon and go to "Prepare" then "Properties."

4. 

   Click on "Document Properties" then "Advanced Properties."

5. 

   Look at "Modified" in the "Properties" dialog box. The "Modified" field is the date that the workbook was last updated.

Tips & Warnings

• The modified date can also be found by right-clicking on the workbook then going to "Properties."

• The screens may look different but the concept is the same for previous versions of Excel.

Resources

• Microsoft Excel Overview