Solved

Excel file are not locked properly

Posted on 2016-09-29
6
49 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 8

Expert Comment

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

Author Comment

by:deewave
ID: 41822473
single
0
 
LVL 8

Expert Comment

by:J Spoor
ID: 41822474
excel often opens file in a read only mode, only when clicking edit will it lock
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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 Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

696 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