Excel file opens in read-only mode from one server but not another

  • Thread starter Thread starter Joe Nocella
  • Start date Start date
J

Joe Nocella

Guest
I have a couple of users that are receiving the following error message when
they attempt to open an excel file on a personal network home share. The
share resides on a Windows 2003 server which is to date with all service
packs and updates. The client is Windows XP Professional SP2 with all updates
applied.

I've checked out the following KB articles:

http://support.microsoft.com/kb/814112
http://support.microsoft.com/kb/214073
http://support.microsoft.com/kb/313472

When I copied the folder that contains the files to another server and
attempt to open open of the excel documents I do not receive the error. So
it's something to do with this one server. I've tried disabling anti virus
thinking that maybe Real time virus scan had the file open.

ERROR MESSAGE
========================
File in use

"filename.xls" is is locked for editing
by johnw.

Open read-only or click notify to open read only and receive notification
when the document is no longer in use.

=====================

When you go into Computer Management > Shared Folders> open files, the file
is not actually open at all.

Thanks!!!!!!
 
Re: Excel file opens in read-only mode from one server but notanother

Re: Excel file opens in read-only mode from one server but notanother

On May 8, 4:17 pm, Joe Nocella <jnoce...@strasz.com> wrote:
> I have a couple of users that are receiving the following error message when
> they attempt to open an excel file on a personal network home share. The
> share resides on a Windows 2003 server which is to date with all service
> packs and updates. The client is Windows XP Professional SP2 with all updates
> applied.
>
> I've checked out the following KB articles:
>
> http://support.microsoft.com/kb/814.../214073http://support.microsoft.com/kb/313472
>
> When I copied the folder that contains the files to another server and
> attempt to open open of the excel documents I do not receive the error. So
> it's something to do with this one server. I've tried disabling anti virus
> thinking that maybe Real time virus scan had the file open.
>
> ERROR MESSAGE
> ========================
> File in use
>
> "filename.xls" is is locked for editing
> by johnw.
>
> Open read-only or click notify to open read only and receive notification
> when the document is no longer in use.
>
> =====================
>
> When you go into Computer Management > Shared Folders> open files, the file
> is not actually open at all.
>
> Thanks!!!!!!


You could either ask the user ("johnw" - in your message above) to
open then close the message. This should free it up. Alternatively you
could google a file unlock app such as unlocker
 
RE: Excel file opens in read-only mode from one server but not another

I also checked out this kba:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;328170

BUT - I think I solved it. I was doing a side by side comparison of services
running on both the server where it was and wasnt working. I turned of the
Indexing serive on the server where it wasnt working and I could open the
file normally.

I think this problem is solved!!!!! Man I've been struggling with this one
for weeks. Anyway I hope this information is helpful to someone.


"Joe Nocella" wrote:

> I have a couple of users that are receiving the following error message when
> they attempt to open an excel file on a personal network home share. The
> share resides on a Windows 2003 server which is to date with all service
> packs and updates. The client is Windows XP Professional SP2 with all updates
> applied.
>
> I've checked out the following KB articles:
>
> http://support.microsoft.com/kb/814112
> http://support.microsoft.com/kb/214073
> http://support.microsoft.com/kb/313472
>
> When I copied the folder that contains the files to another server and
> attempt to open open of the excel documents I do not receive the error. So
> it's something to do with this one server. I've tried disabling anti virus
> thinking that maybe Real time virus scan had the file open.
>
> ERROR MESSAGE
> ========================
> File in use
>
> "filename.xls" is is locked for editing
> by johnw.
>
> Open read-only or click notify to open read only and receive notification
> when the document is no longer in use.
>
> =====================
>
> When you go into Computer Management > Shared Folders> open files, the file
> is not actually open at all.
>
> Thanks!!!!!!
 
Got solution for you! (When reopening Excel files it'sRead Only)

Got solution for you! (When reopening Excel files it'sRead Only)

Stop Ms Windows Indexing Service. "That stupid useless p/crap" Right click on my computer | Manage | Indexing Services \ Right click | All tasks | Tune Performance | select "Never Used" click OK. And try to open the excel file again and Walla...
 
Got solution for you! (When reopening Excel files it'sRead Only)

Got solution for you! (When reopening Excel files it'sRead Only)

Stop Ms Windows Indexing Service. "That stupid useless p/crap" Right click on my computer | Manage | Indexing Services \ Right click | All tasks | Tune Performance | select "Never Used" click OK. And try to open the excel file again and Walla...
 
Back
Top