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

[Guest Joe Nocella]

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!!!!!!

[Guest PMC1]

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/814112http://support.microsoft.com/kb/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

[Guest Joe Nocella]

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!!!!!!

[Guest Harry Saryan]

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...

[Guest Harry Saryan]

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...