Excel file are not locked properly
Hi
We are currently experiencing an intermittent issue on our network.
We have a file server (Windows 2012 R2) at our datacenter with several shared folders. It has "Application Server" and "File and Storage service" roles installed.
A VPN is created between location A and the datacenter. Both routers are Sonicwalls (NSA240 and TZ600 respectively)
At location A, user A and B both have a network drive pointing to the same shared folder containing several Excel files.
Most of the times, user A access an Excel file, and when user B tries to open the file, he gets blocked because A is already editing the file. Which is the expected behaviour.
But sometimes, user A access the file, works in it, and meanwhile user B acces the same file, doesn't get any "already in use" warning, works in it, save the file. Then when A tries to save his changes, it says the file is locked by "another user".
User A was the first to open the file.
As a workaround for now, I've asked my users to save their file as soon as it's opened. I was never able to reproduce the problem that way.
Thanks in advance for all your help
We are currently experiencing an intermittent issue on our network.
We have a file server (Windows 2012 R2) at our datacenter with several shared folders. It has "Application Server" and "File and Storage service" roles installed.
A VPN is created between location A and the datacenter. Both routers are Sonicwalls (NSA240 and TZ600 respectively)
At location A, user A and B both have a network drive pointing to the same shared folder containing several Excel files.
Most of the times, user A access an Excel file, and when user B tries to open the file, he gets blocked because A is already editing the file. Which is the expected behaviour.
But sometimes, user A access the file, works in it, and meanwhile user B acces the same file, doesn't get any "already in use" warning, works in it, save the file. Then when A tries to save his changes, it says the file is locked by "another user".
User A was the first to open the file.
As a workaround for now, I've asked my users to save their file as soon as it's opened. I was never able to reproduce the problem that way.
Thanks in advance for all your help
J Spoor
single file server or dfs?
ASKER
single
excel often opens file in a read only mode, only when clicking edit will it lock
ASKER
When I go RDC on the server, and opens the file, it works perfectly. I can save it as expected.
If I open the file from my pc, using the Network Drive, I get an error while trying to save it (currently in use by "another user")
I went on the SonicWall at the datacenter, and disabled the Anti-Virus. Now everything works fine.
I will place a call at SonicWall
If I open the file from my pc, using the Network Drive, I get an error while trying to save it (currently in use by "another user")
I went on the SonicWall at the datacenter, and disabled the Anti-Virus. Now everything works fine.
I will place a call at SonicWall
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
none of the proposed solutions worked