Excel files on W2k Network share "opened by another user"

Lately we've been experiencing a problem with excel files on network drives.

When you open them they say "already opened by (yourself)" and you are
forced to open them read-only....

These files do a SQL query on startup.

I am certain they are not already in use. I've restarted the servers and
workstations.

Any ideas? Suggestions?

Sorry - it's a W2k3 share - and it happens only with Excel files.....


"Paul MacFarlane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Lately we've been experiencing a problem with excel files on network
> drives.
>
> When you open them they say "already opened by (yourself)" and you are
> forced to open them read-only....
>
> These files do a SQL query on startup.
>
> I am certain they are not already in use. I've restarted the servers and
> workstations.
>
> Any ideas? Suggestions?
>

Antivirus and opportunistic locking?
http://support.microsoft.com/kb/296264


Try uninstalling the AV and disable the oplocks..

Regards,

Andrew


"Paul MacFarlane" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Sorry - it's a W2k3 share - and it happens only with Excel files.....
>
>
> "Paul MacFarlane" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Lately we've been experiencing a problem with excel files on network
>> drives.
>>
>> When you open them they say "already opened by (yourself)" and you are
>> forced to open them read-only....
>>
>> These files do a SQL query on startup.
>>
>> I am certain they are not already in use. I've restarted the servers and
>> workstations.
>>
>> Any ideas? Suggestions?
>>
>
>

No AV involved. I'll check OpLocks
"Andrew Lomakin" <(E-Mail Removed)-spam> wrote in message
news:564DD3F2-4520-47DA-9021-(E-Mail Removed)...
> Antivirus and opportunistic locking?
> http://support.microsoft.com/kb/296264
>
>
> Try uninstalling the AV and disable the oplocks..
>
> Regards,
>
> Andrew
>
>
> "Paul MacFarlane" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Sorry - it's a W2k3 share - and it happens only with Excel files.....
>>
>>
>> "Paul MacFarlane" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Lately we've been experiencing a problem with excel files on network
>>> drives.
>>>
>>> When you open them they say "already opened by (yourself)" and you are
>>> forced to open them read-only....
>>>
>>> These files do a SQL query on startup.
>>>
>>> I am certain they are not already in use. I've restarted the servers
>>> and
>>> workstations.
>>>
>>> Any ideas? Suggestions?
>>>
>>
>>
>

Disabling Opslock doesn't help.... This is only happening with these Excel
files that do a SQL query

Same problem message...

"Andrew Lomakin" <(E-Mail Removed)-spam> wrote in message
news:564DD3F2-4520-47DA-9021-(E-Mail Removed)...
> Antivirus and opportunistic locking?
> http://support.microsoft.com/kb/296264
>
>
> Try uninstalling the AV and disable the oplocks..
>
> Regards,
>
> Andrew
>
>
> "Paul MacFarlane" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Sorry - it's a W2k3 share - and it happens only with Excel files.....
>>
>>
>> "Paul MacFarlane" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Lately we've been experiencing a problem with excel files on network
>>> drives.
>>>
>>> When you open them they say "already opened by (yourself)" and you are
>>> forced to open them read-only....
>>>
>>> These files do a SQL query on startup.
>>>
>>> I am certain they are not already in use. I've restarted the servers
>>> and
>>> workstations.
>>>
>>> Any ideas? Suggestions?
>>>
>>
>>
>