Discussion Locked

Excel 2003 Last User

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hey guys,

I need a formula that will show what user last edited a workbook and at what time he/she did this. I know it will have to be a shared workbook but beyond that I'm clueless. Excuse me, kind of new to formulas here.

Second question: What book(s) do you guys recommend for teaching the clueless everything there is to know about using, building and understanding formulas in Excel 2003? Thanks millions guys.

2 replies

by jimklallsoo

Ken, Excel does this for you without the need for formulas.

Open Excel and click File > Scroll down to properties (may be hidden atthe bottom of the file menu).

Click Properties and then simply add the type you want e.g. last accessed by, saved by etc.

This discussion is closed to new replies.