Solved

Excel - displaying username

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

705 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