Free Microsoft Excel 2013 Quick Reference

excel locked by another user=myself

this is for excel 2000
excel crashed while doing some vba code testing
now when re-opening the sheet where crash occurred i get the file is already
open by myself,
read-only, notify msg
is there some way to reset the file lock pointers/file in use/etc without
rebooting?
took a quick look in registry but nothing jumped out at me


Post your answer or comment

comments powered by Disqus
Excel 2007 SP2 : "File in use by another user"

Hellow, i'm having a problem with a customer of mine.
The customer has the following configuration:
Portable with Windows Vista SP2 and Office 2007 SP2 fully updated.
"Sometimes" when the customer opens an Excel workbook 'local or on the network' he gets the message "File in use by another user".
I checked there are no locked files (hidden ~excell)
There is no antivirus installed on the machines. And when the users click away the "File in use by another user" and reopen the workbook it opens fine.
I assume it is a problem between (Operating System / Office installation (image) / Third party software)
My question: how can i troubleshoot this, is there a way to turn on verbose logging for this type of errors. Can is see which file / process has the excel workbook locked?

I need to be able to query data out of an Excel file while that file is open
(for write) by another user. However, if the excel file with the source data
is open (for edit) by a different user, then I get strange behavior when I
refresh the query; it opens the file that has the source data, and then the
application doesn't scroll and redraw correctly.

I am running Windows XP SP2, Excel 2003 SP2.

To re-create...

I have two files:
A.xls
B.xls

Enter data into a A.xls, and define a range = "fred" so that it resembles a
well-formed table. Save the file, but keep it open.

Create another file, B.xls, that queries the "fred" range from A.xls.
- Go to
- That shoudl bring up the "Choose Data Source" dialogue.
- Select, "Excel Files" and click OK.
- select A.xls
- You should see the query wizard
- Select the range, "fred" and select all the columns
- Click through all the "Next" buttons and "Finish"; confirm the query
works OK.

Close B.xls. Keep A.xls open. Go get your best buddy to open B.xls
(different network user). Your buddy will get B.xls and A.xls. (If you both
close all files, then either one opens B.xls, it'll only open B.xls.)

I also tried setting up A.xls as a link table in Access and have B.xls query
that link table, but I get the same erroneous behavior. I have also tried
creating a Data Access Page in MS Access (again using a link table to A.xls)
but MS Access cannot access the data at all if another user has A.xls open
for edit. (It works OK if A.xls is open by another user for read.)

Is there a way to allow MS Access or Excel to query an Excel file even
though that Excel file is open for writing by another user?

....paul...

is locked for editing by 'another user' when Word doc is created on TS saved locally then re-opened

Windows Server 2008 Terminal Server
Office 2007
If a user on the TS opens Word, creates a document then does a SAVE AS to their local machine, then tries to open the document still within the TS the users get "documentname.docx is locked for editing by 'another user' message.
Nobody else has the document open 100%.
If a user then exits their TS session and opens the document locally this works fine, if they then save the document then goes back to the TS the document opens fine.
I can recreate this issue if logged into the TS as domain admin too.
Would really appreciate some help on this one.

We have several users that are trying to open excel from the start menu and
it is telling them the sheet is locked by another user. They can open in
read only, notify or cancel. These aren't shared documents on the network,
they are opening excel and loading the default template. We're experiencing
this all over our company.

We also have people opening documents from their personal network share with
the same message. The server shows no one else connected to the share but
them MOM show's no one else opening the files. It's as if Excel isn't
releasing the lock it places on the file when it is open.

Good morning everyone,

Can i make .docx as locked for editing by 'another users' in Word 2007 .
I want to apply restrictions on the word page that no other users can edit on that page ??

How can i do that?//
Give me some suggestions

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.

I am looking for a way to automatically close a workbook if another user tries to open it when it is open by someone already. I found an earlier post that showed the text below

Private Sub Workbook_Open()

If ActiveWorkbook.ReadOnly = True Then
MsgBox ("Sorry mate, no can do. Try later")
' then do what ever else you need to do to tidy things up if necessary
If ActiveWorkbook.ReadOnly = True Then
End If

End Sub

It works fine but I do not want them to be able to open or modify the sheet. It opens as read only but any modifications cannot be saved.

I would prefer the message box first then the workbook would close.

Something like "This sheet is open by another user the workbook will close automatically"

I am also concerned that if macros are not enabled this will not work, can I do the same if macros are disabled.
thanks
Mike

We recently upgraded to Office XP (from Office 2000) and since the
upgrade, everytime we save a file we are prompted that the file may
have been changed by another user and to save a copy or overwrite
the changes. In my testing, I am the only one that has access to
the file in question, however if a change it made it will still
prompt me. This occurs everytime. Thanks for any assistance.

----------------------------------------------
Posted with NewsLeecher v2.0 RC3
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Hi,

I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
using Microsoft JET database engine, but it gives me an error saying
" Workgroup information file is missing or opened exclusively by another
user"

This error only exists if i use an MS SQL login with a password but it works
fine with a login without a password. My question is, is there a way around
this with a login that has a password?

Thanks

We recently upgraded to Office XP (from Office 2000) and since the
upgrade, everytime we save a file we are prompted that the file may
have been changed by another user and to save a copy or overwrite
the changes. In my testing, I am the only one that has access to
the file in question, however if a change it made it will still
prompt me. This occurs everytime. Thanks for any assistance.

----------------------------------------------
Posted with NewsLeecher v2.0 RC3
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Hi,

I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
using Microsoft JET database engine, but it gives me an error saying
" Workgroup information file is missing or opened exclusively by another
user"

This error only exists if i use an MS SQL login with a password but it works
fine with a login without a password. My question is, is there a way around
this with a login that has a password?

Thanks

I have a workbook which is shared.

If I want to update or replace the shared workbook with updated data, it the same work book is opened by another user, is there any macro or VBA to close all opened workbooks before I update or replace.

Thanks in advance.

Joshi

Hi,

If I am the owner of a workbook which is opened by another user in readonly mode
how can I edit the workbook without getting a prompt "Workbook Already open, do you want to open again and etc.

I use Application.Workbooks.Open (strHeader & strProgram & strType), WriteResPassword:=strPass, IgnoreReadOnlyRecommended:=True
and when workbook is not already open I can open no worries but if opened in read only mode I get "Workbook already open, do you want to open again and etc.

Any ideas thanks

Lionel

Hi

We are using a VBA-Macro which opens about 180 files in order to update them. Sometimes it happens that one of those files, is already in use by another user, then an error message appears which says “A file named ‘XY.xls’ already exists in this location. Do you want to replace it?” Then I press the “No” button. After that a Visual Basic error message pops-up “Run-time error’1004’: ‘XY.xls’ is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box”.

The idea would be that the macro updates all 180 files unless one is already in use. In this case the macro should just close the file without saving.

It would be great to get some help. Thanks a lot.

Michael

Hello,

I'm having the following little problem, and i was wondering
if anyone could help me solve it.

I have an Excel sheet with VBA code in it, who opens 25 other
excel sheets (one by one).

Information is retrieved from these files, and new information is also
written to that file.

However sometimes another user is using one of these files, so
my "main" Excel program can't open and write to this file.

Is there a way to use VBA which displays a message to that user
that the file should be closed within 5 minutes, or automatically
closes that file after 5 minutes when the file isn't closed in time ?

Thanks.

Best regards,
Frits

In Excel 2003 when opening a spreadsheet which was used by someone else it used to specify who was in the spreadsheet however we have now 2007 and changed the file from xls to an xlsm and now it won't specify who in the organisation is using the spreadsheet.

What do i need to do to get the spreadsheet to go back to which user is locking it.

Hello,
Had a file moments ago that was locked by a user who no longer had the file open. The file was out on a network share.

More strange, the user logged back in and tried to open the file and was told it was still open by him and that he could only open it READ ONLY!

Any idea what the problem was?

BTW, I opened the file perhaps 10-15 minutes later and it was no longer locked - spooky!

I have a formatted cell in Excel ($ 600.66) which appears as 600 2/3 when
another user opens the file on their PC. The same version of Excel is used
on both computers. The spreadsheet is locked to prevent users from changing
the formats. Is there a way to resolve the problem and so that number is
formatted consistently no matter who the user is?

Hi All

First post to this NG so apologies if this has been dealt with before

Have installed windows vista and office 2007 on 2 machines. I have tried to
export an access report from another application into excel on each
When excel opens the file on one of the machines there is a prompt which
says the file is 'locked by another user' I select either read only or
notify and the workbook opens in read only format.
I cannot delete the file or the temp file associated with it until I have
rebooted the machine

On the other machine the problem does not arise

I have used the same Vista and office disks for each machine (with different
key codes as I have multiple copy licenses)

Both are clean installs on formatted hard drives

Both are with the administrator as the only user

I have user account notification switched off on both

I have searched the web and found several references to the problem but no
solutions

any help really appreciated

Tony

hello,

how do i prevent an excel file being opened as read only if the file is
already opened by another user. this particular file is on the file server
and accessed by multiple users.

What I want is an alert if the file is already opened which says the file
cannot be opened as read only and click ok to close. the alert to inlcude the
username who has the file opened.

workbook sharing is not an option as it breaks my various vba macros

appreciate any help...

cheers

Dear Friends,

I need a small help. Is it possible to open the same excel file by two users without sharing it? The second user will be sufficed even if it is a "Read-Only" file.

I am against Sharing the workbook, after going through a lot of research. Especially its limitations on worksheet protection.

Thank you,

Regards,
RK.

I am using Excel 2002 and Access 2002.
I am trying to import external data, new database query in Excel to link to a Access table. I keep getting the error Can't access table. when you press help you get the following explination
Can't access table

We have 25 users all accessing a windows 2003 fileserver. Almost all of those users use excel extensively (with large linked spreadsheets many larger than 15mb). However, 2 of them are having recurring problems with approximately 3 spreadsheets.

These spreadsheets lock up occasionally (sometimes after the first open, sometimes after a number of opens and closes). What happens is that any user opens these particular files, and finishes with them (sometimes making changes, sometimes not), they cannot then be re-opened. We get the annoying: "This file has been locked by another user do you want to open read only or notify....".

And the file is blatantly no opened by anyone else. The file isn't registered in the file open console, and no other program appears to be accessing it (norton av and veritas backup exec are runniing on that machine). The only way we can then unlock the file is to reboot the file server. And then after someone uses that file a couple of times it locks up again.

There doesn't seem to be any rhyme or reason to this. Does anyone have any suggestions?

We have 25 users all accessing a windows 2003 fileserver. Almost all of
those users use excel extensively (with large linked spreadsheets many
larger than 15mb). However, 2 of them are having recurring problems
with approximately 3 spreadsheets.

These spreadsheets lock up occasionally (sometimes after the first
open, sometimes after a number of opens and closes). What happens is
that any user opens these particular files, and finishes with them
(sometimes making changes, sometimes not), they cannot then be
re-opened. We get the annoying: "This file has been locked by another
user do you want to open read only or notify....".

And the file is blatantly no opened by anyone else. The file isn't
registered in the file open console, and no other program appears to be
accessing it (norton av and veritas backup exec are runniing on that
machine). The only way we can then unlock the file is to reboot the
file server. And then after someone uses that file a couple of times it
locks up again.

There doesn't seem to be any rhyme or reason to this. Does anyone have
any suggestions?

--
Leander


No luck finding an answer? You could always try Google.