Solved

excel 2010 issue on windows 7

Posted on 2014-03-20
7
178 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
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 39

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
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 

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

Suggested Solutions

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
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 …
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

828 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