Excel - displaying username

Dear experts,

I know in Excel we can input a user name into the field, so that if UserA has a spreadsheet opened the others can see who is in it. I know how to set that too. My question is, how reliable is it?

We have an excel spreadsheet which almost everyone will need to edit. I am sure majority of people has insert their name correctly in that user field, but still majority of time Excel failed to display the correct name as it only shows the spreadsheet is opened by "."!! Will the different edition/version of excel affect this function? I mean, we have a mixture of Excel 2007 and 2010 and the spreadsheet was originally created using Excel 2000. The spreadsheet is stored in a network drive where everyone can access.

Is there anything I can do in Excel to ensure it displays user name correctly? If not in excel, any third party product?

Thx in advance for any suggestion. We are operating in a Win 2003 network but I don't think this matters?
LVL 23
ormerodrutterAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rowansmithCommented:
The Excel Username field is user managed.  A user can always change this from within Excel.  If you trust that users will not change this, then you have several options:

You could use a login script to set the appropriate registry key, for Office 2007 look here:
HKEY_CURRENT_USER\Software\Microsoft\Office\Common\UserInfo

For Office 2003 here:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\UserInfo\UserName

You could also consider using Group Policy, information for which you will find here (atleast to get you started):  http://technet.microsoft.com/en-us/library/cc179057(v=office.12).aspx

As you have such a large mix of Excel versions, you're going to need to do something quite  specific for each installation and I suspect this is going to take a bit of testing, especially if you have multiple people sharing a machine...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.