MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can you change "Who" when tracking changes in a Shared Workbook?

Posted by Mason on January 31, 2001 9:16 AM

When you share a workbook, highlight changes, and then view the tracking history, "Who" made the changes appears to be to whomever the software is licensed. Does anyone know of a way to enter a different name as the person making the changes? We have a multi-user license, so the software is installed with our department "OIT" as the name, and we want each individual's changes tracked. Thanks!

Posted by Mark W. on January 31, 2001 9:21 AM

Go to the Tools Options... General tab and change
the contents of the "User name" field.

Posted by Mason on January 31, 2001 9:30 AM

Thanks so much, Mark! I can't believe I missed that. I really appreciate your timely help.