Solved

Excel - displaying username

Posted on 2012-03-28
1
145 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
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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…

772 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