Solved

excel 2010 issue on windows 7

Posted on 2014-03-20
7
200 Views
Last Modified: 2014-09-15
I have 3 users who work on an excel file in a shared drive. They recently got upgraded to windows 7 and since they are having problems saving the changes in excel file.

They get the following message when saving the changes.

Your changes could not be saved to 'xxxxx.xlsx' because of a sharing violation. Try saving to a different file.
0
Comment
Question by:ahmshaki
[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
7 Comments
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 39943263
I have recently solved this issue by disabling the offline availability. It was caused by a sync issue and that solved it quickly and cleanly.
0
 
LVL 41

Expert Comment

by:Adam Brown
ID: 39943290
You're getting that error because two people are accessing and modifying the same file at the same time. Excel files can only be opened and edited by one person at a time. If users edit an offline copy of the file at the same time and one or the other has saved a different version to the storage location, you'll get this error.
0
 

Author Comment

by:ahmshaki
ID: 39943321
thanks for the suggestions.
if you mean offline files in windows. it is already disabled by group policy.
The file is accessed only by one person at a time and she still can't save changes to the file and gets the above message.
0
Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

 

Accepted Solution

by:
ahmshaki earned 0 total points
ID: 39945426
I opened the file, did a Save As, changed the name to xxxtest. in excel went to Review tab--> Sared Workbook and changed the settings. Then under Review Tab went to Track Changes and and changed the settings. save and close.

Opened the xxxtest and udated the file- save and close. other two users are able to see the changes to the file, and no more messages popup now.
0
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 39945450
If the error comes back, disable the offline availability in Windows Explorer for that file or folder.
0
 

Author Closing Comment

by:ahmshaki
ID: 39968798
We tried it and worked perfectly
0
 
LVL 13

Expert Comment

by:Rizzle
ID: 40322932
Hi ahmshaki

We have this issue with a couple of our users and I wanted to know what settings you changed as per your above solution?
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

623 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