Solved

Excel - displaying username

Posted on 2012-03-28
1
147 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:ormerodrutter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
rowansmith earned 500 total points
ID: 37776134
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...
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question