B
Brad Pears
We have a "shared" Excel 2000 spreadsheet that various users can access.
Whenever one particular user has it open, and another user attempts to open
it, it always says that a completely different user (other than who actually
has it open) has it open for editing.
Today for instance, this particular user I am referring to above had it open
("jnewitt"). Another user ("slockwood") attempted to open the spreadsheet as
well using her Win2K terminal services session, and was told that the file
was locked for editing by user "slockwood" - the same user who was
attempting to open it in the first place. Clearly incorrect reporting by
Excel!
I made sure she did not have a lock on it at all by checking system
resources on teh Win2K server etc... and she did not. I finally discovered
who actually did have the file open and it was the "problem" user referred
to above.
Why would Excel always be reporting the wrong username for this user? Where
is Excel actually obtaining the username that has the file open from?? We
have had problems with this user before - but only this user!!!. It will
never give his username if he has it open - it is always a different
username. Usually it shows as "draft4" - a user that does not even exist on
our systems any longer!!!
This user runs an XP Professional machine (upgraded from WIn98) and logs
onto it locally using his username "jnewitt". Like I said earlier, anytime
he has a spreadsheet open and another user attempts to open the same one,
they always get a message that "user draft4 has it open for editing" - of
course draft4 does not even exist as a user - and is not a local user on his
machine either. In fact I searched his entire registry for any reference to
"draft4" and found none. Somewhere it is buried on the machine and Excel is
using it, thinking that draft4 is the logged on user!!!
Does anyone have any ideas on this issue or where Excel might be getting
this from??
Thanks,
Brad
Whenever one particular user has it open, and another user attempts to open
it, it always says that a completely different user (other than who actually
has it open) has it open for editing.
Today for instance, this particular user I am referring to above had it open
("jnewitt"). Another user ("slockwood") attempted to open the spreadsheet as
well using her Win2K terminal services session, and was told that the file
was locked for editing by user "slockwood" - the same user who was
attempting to open it in the first place. Clearly incorrect reporting by
Excel!
I made sure she did not have a lock on it at all by checking system
resources on teh Win2K server etc... and she did not. I finally discovered
who actually did have the file open and it was the "problem" user referred
to above.
Why would Excel always be reporting the wrong username for this user? Where
is Excel actually obtaining the username that has the file open from?? We
have had problems with this user before - but only this user!!!. It will
never give his username if he has it open - it is always a different
username. Usually it shows as "draft4" - a user that does not even exist on
our systems any longer!!!
This user runs an XP Professional machine (upgraded from WIn98) and logs
onto it locally using his username "jnewitt". Like I said earlier, anytime
he has a spreadsheet open and another user attempts to open the same one,
they always get a message that "user draft4 has it open for editing" - of
course draft4 does not even exist as a user - and is not a local user on his
machine either. In fact I searched his entire registry for any reference to
"draft4" and found none. Somewhere it is buried on the machine and Excel is
using it, thinking that draft4 is the logged on user!!!
Does anyone have any ideas on this issue or where Excel might be getting
this from??
Thanks,
Brad