View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default Shared Workbook Locked for Editing


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:
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 "locked for editing by user - "XXXXXX" Read Only...."

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
"kick" 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!



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=536673