software

Hello,

We are using a shared workbook in an office with up to 25 users sharing
the workbook at any given time. Currently we are getting an error that
states quot;locked for editing by user - quot;XXXXXXquot; Read Only....quot;

The problem is that the username is generic and could by anyone. We
have had everyone log out of excel to clear it up, but it is still
giving us that same error. Does anyone have any suggestions as how to
quot;kickquot; whichever user is locking it up so that we can gain access again?
Our plan is that once we get in there we will have everyone correct the
username fiasco by placing unique info in there, but until then we are
stuck.

I appreciate any assistance!

Oh yeah, it's Excel 2003.
Thanks!--
three6ohchris
------------------------------------------------------------------------
three6ohchris's Profile: www.excelforum.com/member.php...oamp;userid=13195
View this thread: www.excelforum.com/showthread...hreadid=536673
Try a Taskmanager view of Processes to see if you have any hidden
occurrences of Excel.exe on each machine in the system, then (probaly
at night) ensure that all pc's shutdown to release any spurious locks.

Alternatively you may be able to copy the workbook to a different area
and use that temporarily, I doubt that you will be able to rename the
original until you release the lock.

Hope this helps

--

three6ohchris Wrote:
gt; Hello,
gt;
gt; We are using a shared workbook in an office with up to 25 users sharing
gt; the workbook at any given time. Currently we are getting an error that
gt; states quot;locked for editing by user - quot;XXXXXXquot; Read Only....quot;
gt;
gt; The problem is that the username is generic and could by anyone. We
gt; have had everyone log out of excel to clear it up, but it is still
gt; giving us that same error. Does anyone have any suggestions as how to
gt; quot;kickquot; whichever user is locking it up so that we can gain access again?
gt; Our plan is that once we get in there we will have everyone correct the
gt; username fiasco by placing unique info in there, but until then we are
gt; stuck.
gt;
gt; I appreciate any assistance!
gt;
gt; Oh yeah, it's Excel 2003.
gt; Thanks!--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=536673
Bryan Hessey Wrote:
gt; Try a Taskmanager view of Processes to see if you have any hidden
gt; occurrences of Excel.exe on each machine in the system, then (probaly
gt; at night) ensure that all pc's shutdown to release any spurious locks.
gt;
gt; Alternatively you may be able to copy the workbook to a different area
gt; and use that temporarily, I doubt that you will be able to rename the
gt; original until you release the lock.
gt;
gt; Hope this helps
gt;
gt; --
Thanks for the suggestions. We are going to have to wait for the night
to roll around and the network connections to reset. Hopefully tomorrow
we will be good to go.--
three6ohchris
------------------------------------------------------------------------
three6ohchris's Profile: www.excelforum.com/member.php...oamp;userid=13195
View this thread: www.excelforum.com/showthread...hreadid=536673
If the TaskMgr proved fruitless, yes. Of course, you need only one
network connection to reset, but experience always shows that's the
last one, and usually one that you have to seek out after all others
have gone.

Good lucl

--

three6ohchris Wrote:
gt; Thanks for the suggestions. We are going to have to wait for the night
gt; to roll around and the network connections to reset. Hopefully
gt; tomorrow we will be good to go.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=536673