[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Excel file are not locked properly

Posted on 2016-09-29
6
Medium Priority
?
63 Views
Last Modified: 2016-10-12
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
0
Comment
Question by:deewave
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 9

Expert Comment

by:J Spoor
ID: 41822469
single file server or dfs?
0
 

Author Comment

by:deewave
ID: 41822473
single
0
 
LVL 9

Expert Comment

by:J Spoor
ID: 41822474
excel often opens file in a read only mode, only when clicking edit will it lock
0
Q2 2017 - Latest Malware & Internet Attacks

WatchGuard’s Threat Lab is a group of dedicated threat researchers committed to helping you stay ahead of the bad guys by providing in-depth analysis of the top security threats to your network.  Check out our latest Quarterly Internet Security Report!

 

Author Comment

by:deewave
ID: 41828022
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
0
 

Accepted Solution

by:
deewave earned 0 total points
ID: 41833966
SonicWall suggest to exclude to server's IP on GAV

From the case description, I understand you have issue with GAV.

If I am right, you can exclude the IP for the server on GAV.

Please follow the below KB article for the same.

https://support.software.dell.com/kb/sw11728

I am available from 9 AM to 6 PM EST to work on this.


It does work, but I'd want to understand and correct the problem, instead of this workaround.
0
 

Author Closing Comment

by:deewave
ID: 41839777
none of the proposed solutions worked
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question