Who knows about origin of a Microsoft Excel Spreadsheet

**vALaNCiA** · 07-02-2012

Does ANYONE know if it is possible to find the origin of a spreadsheet. By this i mean is it possible to track who (Computer Name) or what PC (IP Address) created an excel document. For example say Bob created a Excel document but i don't know he did it, but i need to find out. How do i find out Bob Created it. Is it possible.

**Hollyn** · 07-02-2012

You can check the document properties by clicking on FILE and selecting PROPERTIES. This might have the information that you need regarding the originator of the work sheet.

**QUENBY** · 07-02-2012

On the tool bar click file > properties. It may not give you the information you listed below but it should take you to logon name of the author, last saved by, date created, date last modified, etc. There is a lot of other info there but it has to be filled in manually and most people don't bother with that.

**GALIENA** · 07-02-2012

If you are not against using code, here is a macro that pastes the author and creation date.

Code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = _
ThisWorkbook.BuiltinDocumentProperties("Author")
Sheets("Sheet1").Range("A2").Value = _
ThisWorkbook.BuiltinDocumentProperties("Creation Date")
End Sub