Solved

excel 2010 issue on windows 7

Posted on 2014-03-20
7
189 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 40

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

734 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