Forum home » Delegate support and help forum » Microsoft Excel Training and help » Last saved functionality

Last saved functionality

ResolvedVersion 2010

Wed 9 May 2012, 08:56 Delegate Todd said...

Todd has attended:
Excel Advanced course

Last saved functionality

Hi there,

I am trying to understand if it is possible to have a code or some other feature that allows the contents of a cell within Excel 2010 to contain the 'last saved' date/

Any help appreciated.

Thanks

Mon 14 May 2012, 12:54 Trainer Anthony said...

RE: Last saved functionality

Hi Todd, thanks for your query. You can't save individual cells, only whole workbooks and there is no out of the box functionality to get at the last saved date. However, if you don't mind messing around with a few lines of code this might help:

http://answers.microsoft.com/en-us/office/forum/office_2003-excel/print-the-last-saved-time-and-date-stamp-in-an/2e779b05-cbf6-44de-8600-11c0d8311d53

Hope this helps,

Anthony

Mon 21 May 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Last saved functionality

Last saved functionality

RE: Last saved functionality

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet