Solved

excel 2010 issue on windows 7

Posted on 2014-03-20
7
165 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 38

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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PMP prep 5 94
Read NFC tag from long distance 10 111
Office for Mac 2016 autosave feature in Word and Excel not working 11 1,562
outlook 2016 orgnize ideas 2 70
Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

912 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now