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
Solved

Excel - displaying username

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

840 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