Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Worksheet Says Locked For Editing By A User Who Is Not In Workshe.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I keep getting a message that a worksheet is locked by another user who is
not using that worksheet. I've tried shutting down etc. with no luck. Thank
you in advance for any help.



Similar Excel Video Tutorials

Helpful Excel Macros

Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text
- This macro will display a message box in excel when a cell reaches a certain value or contains certain text. This means
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
- Add data validation input messages to cells in Excel with this free Excel macro. These messages appear when a specific
Pop-Up Message Box When a Range of Cells Reaches a Certain Average
- This macro will display a message box when the numbers within a range of cells reaches an average of 5. The current mac
Output the Worksheet Name in a Cell in Excel - UDF
- UDF to return the name of the worksheet in Excel on which this function is located. There are no arguments for this fun
Print The Current Worksheet in Excel
- This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are currentl

Similar Topics







Hi,

I have a locked worskheet. Is there a way to prevent that mesage that appears when someone double clicks or trys to enter a cell of a locked worksheet? I would like to create my own custom message. I tried disabling alerts but no luck. Thanks for any ideas.


We just changed servers over the weekend. If we try to open a
spreadsheet and someone already has it open, it gives a message that
it is locked for editing by another user, but it says "." for the
user. In other words, for some reason it isn't giving us the
informaiton who has it locked.

Suggestions???
ga
George Applegate
gappleg8@fmctc.com



I'm currently running a shared spreadsheet between 14 office managers. Whenever one manager is editing and another tries to open the document we get a "locked for editing by 'user'" message.

Is there anyway to change 'user' to the actual user id.


We have 250 users total. excel was installed from a network image.

Thank you for your time.


I have cells that are locked and the worksheet and workbook are password protected. Is it possible to suppress the Excel message (ie the one that says the cells are locked and hence read only. To unlock need to unprotect sheet first ...) when those locked cells are clicked or when one wants to change the content in the cell?

Or alternatively, if the message can't be suppressed, can I write some code that will automatically click OK to that message, but then once the OK button is pressed, it will display my own customised message to give instruction to the user to do something else?
Thanks!


Hi,

I'm looking for the simplest way to lock/protect a worksheet such that:

1) The user edit cells designated with that permission (some cells will need to be locked, others permitted for editing the value)
2) The user has no other privileges on that sheet.

PS 1: It would be helpful if rather than allowing cells one by one I could specify ranges of editable cells.
PS 2: I don't mind if the format of the cell is locked or not, but would be nice to know how to allow/disallow this for the cells who's values can be edited.

Any help greatly appreciated

Thanks in advance


I think I have been asking the incorrect question in previous posts. I have 70 files on a shared drive that I run 1 Macro on. However, sometimes my co-workers are working in the documents and I'll get a "NYC is locked for editing" message. When this happens, I have to re-run my entire Macro all over again. Is there a way to see if any of the workbooks I am trying to open and run a my Macro on are "locked for editing". If any are locked for editing, then I would want to exit sub before running my main Macro. I have all of the file paths in a workbook in column A. Thanks in advance




example.....

I:\Shared\NYC.xls
I:\Shared\Boston.xls
I:\Shared\LA.xls
I:\Shared\Chicago.xls
I:\Shared\Philly.xls


I have an excel 2000 spreadsheet which is locked (worksheet protected using a password). For cells requiring direct user input, the cell's 'locked' property is unticked. However, if text is copied from a Word document into one of these unlocked cells, this property is then set to 'locked', even though the worksheet is protected (and 'format cells' is greyed out). This means the user cannot change or delete the info they've just pasted!

the same also occurs in Excel 2003

How can I prevent this change to the 'locked' property?

Thanks in advance!


Situation : Windows XP Sp2 clients with Office 2003 Sp2 and Samba Domain:
(running Red Hat Enterprise Linux AS release 3 with Taroon Update 7)

On a random share are some XLS documents opened with Excel 2003.
When I open for example document.xls with user “X” (username filled in in
Excel General Options > User name) user “Z” cant open the document because
the document is locked.
Normally the username of the user who has the document open will show up,
when you try to open a document which is already opened.

But in this case, the username shown in “Document.xls is locked for editing
by random name” isn’t really the person who has the document open, it shows
the username who LAST SAVED the document, or in some cases, the user who has
last opened the document.

For example: Document.xls, last saved and closed by user “X” (shown in the
properties of the document) is being opened by user “Y” (also shown “Y” in
EXCEL user options). User “Y nor saves or closes the document, just opens it.
When user “Z” now tries to open the document, a message wil appear:

“ File in Use “
“document.xls is locked for editing by “X”

But user “Y” has the document open, not user “X” …

This is really frustrating some people here, because they don’t know who
really has the document open.

Anyone familiar with this situation ?
For more info please ask.




At work we have Excel 2007 and we have a log of all the tests we do that only the Managers can edit, but we can all view. When we switched from 2004 to 2007, if the excel file was open it stopped saying who it was "locked for editing" by. It did say it in 04, but not in 07. Every other file (ones that are not locked w/ passwords) will say who it is locked by. The locked log simply says locked by "another user". Is there anyway to change this so it says who it's locked for editing by?


I have an excel 2000 spreadsheet which is locked (worksheet protected using a password). For cells requiring direct user input, the cell's 'locked' property is unticked. However, if text is copied from a Word document into one of these unlocked cells, this property is then set to 'locked', even though the worksheet is protected (and 'format cells' is greyed out). This means the user cannot change or delete the info they've just pasted!

How can I prevent this change to the 'locked' property?

Thanks in advance!


answer seems to be to disable Paste, and redirect ^v to paste special the value




Using Active Directory, MS clustered file server, Office 2003

When a group of users access the same file, of course they get a
message stating that
the file is locked by some other user and it usually gives the person's
name that has the
file locked. The exception is that when a particular user has the file
locked, it does not
give that person's name, it simply says 'Nursing'. Since the word
nursing does appear
anywhere in the user's active directory property sheet, I was hoping
somebody could
tell me where excel is getting the data for the user who has the file
locked.

Thanks in advance,

John




Using Active Directory, MS clustered file server, Office 2003

When a group of users access the same file, of course they get a
message stating that
the file is locked by some other user and it usually gives the person's
name that has the
file locked. The exception is that when a particular user has the file
locked, it does not
give that person's name, it simply says 'Nursing'. Since the word
nursing does appear
anywhere in the user's active directory property sheet, I was hoping
somebody could
tell me where excel is getting the data for the user who has the file
locked.

Thanks in advance,

John




Hi, I don't know if this is the correct thread, but here goes.

When users try to access a shared Excel workbook from the server, we get a message saying that the file has been locked for editing by "username". The only problem is that the file has already been closed by the user.

I can go to computer management and release the share of that file, but I'm looking for a fix to avoid any user intervention.

This has been going on for the last couple of days and is driving me nuts.

Any suggestions?


I cannot view or change the data in my worksheet because I am getting this
message. Why, and how do I unlock it?

Thanks for your help.

gman



Here is my Dilemia

I have a worksheet that has been designed to allow the user to enter data, in certain cells of the worksheet are formula to do automatic calculations as the user enters data. Here is my dilemia

a) I need the cells with the formula's to be locked so the user cannot delete or alter them.
b) In cases there may be a case where rows will have to be deleted or inserted, depending on the data entered.
c) The sheet needs to be protected to avoid the user from altering the sheet i.e. design etc.

I have found the problem is that i can lock out all the cells that i do not want the user to alter, and i can protect the worksheet and allow users to have certain edit right. But the problem i am facing is that when you have locked or protected cells on a wprksheet and you protect the sheet, then you can not delete or insert rows.

Is there a way that allows the sheet and formula to be locked, but also allow the user to delete or insert rows if they need...???

I hope this explains every thing...

Sorry for some reason pc acting funny and posted this twice...


I have written a usage log into a spreadsheet to see who is entering the sheet, this is fine but some user names are not shown, only the time they entered, all macros are activated but there name is hidden, why is this?

Also if someone is in a sheet no matter what worksheet they are in and i try to go in, it comes up read only, but instead of it saying, "The sheet is locked for editing by FBF" i says " The sheet is locked for editing by ."

Anyone got any answers please

Thanks

FBF


Ladies and Gentlemen:

In my worksheet, I have a column with all cells in that column locked
(It is a must and I CAN NOT unlock any cell in that column). There are
a few cells UNDER OTHER COLUMNS unlocked for user to input their data.
Then the whole worksheet is password-protected. My question is how to
allow user to copy one ROW and paste it into another row without
unprotect the worksheet? Please keep it in mind that there is at least
one cell in EACH ROW locked where user CAN NOT modify the value in that
cell.

Thanks for your help!

George




Hi everyone,
I am trying to design a worksheet so some of the cells will be locked for editing but others the user will be able to type in freely. When I protect the sheet, everything gets locked down. How do I specify which cells I want protected?

Thanks,
Will


Heres a question.

Is it possible by VBA or other means to allow a user to format cells within a protecetd worksheet.

I jave a worksheet which has locked cells and is also protect, to protect formula's

What i would like todo is on the cells that the user can enter data, is to allow them to use the Undeline, Bold, and Italic functions only.

Is this possible

G


file locked for editing , can I kick the other user out if its my file?

I have made an excel file where other people have to go in and update it. This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance.
Is there anyway I can "kick" them out my file? Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker..
Its really doing my head in... pls help


Looking for a way to unlock a shared excel workbook on a network drive. It currently states that a user has the file locked for editing which he does not. He is not in the file and he has already rebooted his machine. I cannot save as and write over the existing file because the file is supposedly "In Use" by the person whom it claims has it locked for editing. I cannot save as a new name because over 200 people use this file and are already mapped to its home location. Help!?


Hi all - I have a worksheet that only allows users to select unlocked cells so that they can only input the correct data (there is a host of formula, etc around this). I grouped a selection of the rows as it looks quite busy otherwise, but would like end-users to be able to open these up to see the budget / cumulative figures as and when they want. Problem is that the grouped fields are unaccessible (i.e. cannot be expanded / contracted) once the worksheet is locked - does anyone know how to make these available in a locked down worksheet??

Many thanks in advance for any help and it's worth noting that I'm working in Excel 2007

doowop




I have created two macros, one to lock a worksheet, and another to unlock it. I inserted two form control buttons at the bottom of the worksheet, and assigned the macros to the buttons. So now I can toggle between a locked and unlocked worksheet. But I can't tell if the sheet is locked or not.

Now I would like to be able to see if the worksheet is locked or not. Ideally, I'd like one button that toggles the worksheet protection on and off, and the word in the button changes between "Locked" and "Unlocked". Or, I can still use two buttons, perhaps with the "Locked" word or "Unlocked" word changing color so that I can tell the locked status.

Any help appreciated!

Hi,

I was wondering if i could get some help with my problem. In a workbook, i have two worksheets, namely, Schedule and Control.

I have VBA codes written in worksheet "Control". The problem i'm having is that i was trying to stop users from editing a certain number of cells in worksheets "Schedule" but not all the cells.

For example, Cells from D10 to F30 are to be locked (not allowing to be edited) but users can edit cells from G10 to I30 in worksheet "Control".

So i have a simple code written in "Control" worksheet but got error message saying "method data not found".

Worksheets("Timesheet").Activate
Worksheets.Range("D8:F10").Locked = true

Thank you in advance


I have locked all of a worksheet, except for a data entry portion. During
the locking proceedure, excel appears to give options for allowing the user
permission to use certain functions while the worksheet is locked, such as
"sort". However, that is not being allowed. Any ideas?