• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

excel 2010 issue on windows 7

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
ahmshaki
Asked:
ahmshaki
1 Solution
 
Norm DickinsonGuruCommented:
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
 
Adam BrownSr Solutions ArchitectCommented:
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
 
ahmshakiAuthor Commented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ahmshakiAuthor Commented:
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
 
Norm DickinsonGuruCommented:
If the error comes back, disable the offline availability in Windows Explorer for that file or folder.
0
 
ahmshakiAuthor Commented:
We tried it and worked perfectly
0
 
RizzleCommented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now