| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
.xls is locked for editing. Really strange.
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 isnt 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 dont know who really has the document open. Anyone familiar with this situation ? For more info please ask. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
.xls is locked for editing. Really strange.
Someone who can maybe help me ? :)
Gr,, "Sander16v" wrote: 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 isnt 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 dont know who really has the document open. Anyone familiar with this situation ? For more info please ask. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
.xls is locked for editing. Really strange.
maybe:
http://contextures.com/xlfaqApp.html#ReadOnly or http://contextures.com/xlfaqApp.html#AlreadyOpen Both from Debra Dalgleish's site. But if the file is save on a network drive, you may have to get your IT folks to reboot that server. It may help. Sander16v wrote: 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 isnt 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 dont know who really has the document open. Anyone familiar with this situation ? For more info please ask. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Able to overwrite locked cell in protected sheet | Excel Discussion (Misc queries) | |||
| Still can select locked cells in protected sheet | New Users to Excel | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
| Viewing LOCKED cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
