ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel "Last Saved" in Footer (https://www.excelbanter.com/excel-discussion-misc-queries/44611-excel-%22last-saved%22-footer.html)

Tylast

Excel "Last Saved" in Footer
 
It would be nice to have the LAST SAVED date/time in the footer info & not
just the current date/time. I know there's a crazy work around that involves
some code, but come on.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

JE McGimpsey

I've always had difficulty with that approach:

1) File is saved at 9/9/2005 14:45
2) File is printed at 9/9/2005 14:46
-footer says 9/9/2005 14:45
3) File is edited without saving
4) File is printed at 9/9/2005 15:02
-footer says 9/9/2005 14:45
5) File is closed without saving.
6) File is opened and edited without saving.
7) File is printed at 10/4/2005 12:00
-footer says 9/9/2005 14:45

One now has three different documents, all with the same date/time in
the footer with no indication of which occurred when. I'm not sure what
the utility is in credible business situations.

I've had clients ask for this before, but when I point out the above
scenario, they've always opted not to implement it.

In article ,
Tylast wrote:

It would be nice to have the LAST SAVED date/time in the footer info & not
just the current date/time. I know there's a crazy work around that involves
some code, but come on.



All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com