File Locked for Editing

  • Thread starter Thread starter howard
  • Start date Start date
H

howard

I posted this problem a little while ago, and while I have
had several responses none of them have proved helpful.

I have one XLS file that gives me a message on attempting
to open that:

XXX.XLS is locked for editing by user xx

The user is always me. This is a single user workstation,
Windows XP Pro, Excel 2000.

This just started happening recently.

The only thing unusual about this particular XLS worksheet
is that it uses the Microsoft stock quote add-in.

The only thing that cures the problem and allows me to
edit the file again is a reboot. After a reboot I can
access the file for a little while. Then it gets locked
somehow. Even if I never exit from Excel, I get a message
that the file is locked and cannot be saved.

I have tried the following suggestions without improvement:

1. Re-registered Excel
2. Renamed the file
3. Opened the file from within Excel rather than using
Windows Explorer.
4. The file is not a networked file and none of the
suggestions involving network fixes are applicable.

I am highly suspicious at this point that there is some
flaw in the Microsoft Stock Quote macros that is causing
this, as I never see it with any other .XLS file except
the one that uses the Stock Quote macros. Since the whole
point of the spreadsheet is to monitor stock data,
suggestions to not use the Stock Quote macro would not be
helpful.

Any further ideas?

Thanks,
Howard
 
Hi Howard,
Are you saying the workbook is opened, and has been for sometime, when you
get the file locked message?
 
H John,

It happens both ways. I can close the workbook, and re-
open it sometime later and get the message that it can't
open it.

I can also leave the workbook open, and sometime later get
the message that it can't be saved because it is locked.

Howard
 
Hi Howard,
I don't know of the Microsoft stock quote add-in, but I would suspect it's
operating system related.
winnt, win2k, winxp have some nasty habits caching files especially those on
remote drives.
It may be that the o/s is refreshing the cache or "open files table" and
catching your file in it.

At your own risk...
You might try opening the task manager while Excel is running and changing
the priority in the processes tab.
Right click Excel.exe and do set priority. I would avoid Real Time, as you
will lose control of the o/s.

Otherwise I suggest you contact MS directly.
 
Hi Howard,

I see that you are still struggling with this challenge.

If you like, send me your file and I will see if I have difficulty with it.
If I don't, I will rename it and send it back to you.

My email is my last name then the at symbol followed ya then hoo, one word,
and you know the rest.

Post back here when you have sent your message. I will then check my mail.

Regards,
Kevin
 
Howard,

Howard,

<<Do you have MSN Stock Quotes installed? >>

Q: Do you mean the query file? Ans: No, but I can and will if you send the
file.

Q: Do you mean the applet from MSN that allows me to use their site and
have a portfolio and stock quotes? Ans: Yes, I do.

Regards,
Kevin
 
Kevin,

I have sent my xls file to your email address. Thank you
for taking a look at it.

Howard
 
Back
Top