Help with Excel file

[cjv4life]

I am using Office 2003. I have an Excel spreadsheet that I have set up to track changes on. I have it set to show Who and When these changes are made. I looked today to see what changes are made and noticed that the Who field all has the same general name. My question is this: Where is the value of the Who field coming from? Is this the Company Name put in when Office was first installed? If so, how do I go about changing this value to a Users name so I can tell who changed the file? Thank you for any input.




Chris

[Colin Legg]

Hi Chris,

This isn't a feature I've used in Excel - I completely avoid using shared workbooks because of the endless problems associated with them - so the help I can give you will be limited to research rather than experience. The username comes from the field under Tools > Options > General Tab > User name (at the bottom). As you can see, it isn't a secure or static field: users can change it to whatever they want.

Hope that helps...
Colin

[cjv4life]

Thank you for that information. That is exactly what I was looking for.


Chris