Solved

Strange Excel problem

Posted on 2013-10-24
3
224 Views
Last Modified: 2013-10-28
I have 2 users sharing an Excel work book file not at the same time but one user addes data saves it. They can close it and reopen it and the changes are there but another user opens it and doesn't see the new changes. Its on a Network share. Is there some new feature in Excel they could have turned on I don't know about that maybe only displays changes the one user made. Other than that I can't figure it out.
0
Comment
Question by:Axis52401
[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
  • 2
3 Comments
 
LVL 36

Expert Comment

by:Kimputer
ID: 39597725
You can try to open the file at the same time. If Excel doesn't warn you, it means the sharing function has been enabled. It's my experience, this sharing function is prone to data corruption, and showing different user different data. In this case I would DISABLE this function, and continue as you did before (users never open at the same time).
0
 
LVL 16

Accepted Solution

by:
gurutc earned 500 total points
ID: 39597743
Hi,
This can happen for a couple of reasons, SMB2's offline caching is one.  But also you should set the file work book as shared.

In the file, go to review tab, you can see the share and protect options.

You need to configure these.  Clici Protect and Share workbook and then check sharing with track changes.

Also SMB2 might be causing the PCs from not properly updating the network location in a timely fashion.  I'd turn it off on the server and workstations.

Instructions for turning off SMB2 are given in this Microsoft KnowledgeBase article: "How to enable and disable SMBv1, SMBv2, and SMBv3 in Windows Vista, Windows Server 2008, Windows 7, Windows Server 2008 R2, Windows 8, and Windows Server 2012" http://support.microsoft.com/kb/2696547

- gurutc


<<The site is on a campaign to improve thread quality and Google page rank by eliminating blind links. A blind link is one that has no accompanying text other than possibly a "See here" or similar. Blind links are subject to deletion when encountered in a question thread, but I felt the subject matter was germane to the discussion, and so added the type of text (shown in italics above) that we'd like to see accompany a link.
byundt--Microsoft Excel Topic Advisor>>
0
 
LVL 16

Expert Comment

by:gurutc
ID: 39606144
will follow guidance byundt!
0

Featured Post

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

717 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