?
Solved

Excel cannot re-open it because of a sharing violation

Posted on 2011-09-11
5
Medium Priority
?
4,798 Views
Last Modified: 2012-05-12
Recently several users are getting the message "The document was saved successfully, but Excel cannot re-open it because of a sharing violation.  Please close the document and try to open it again"  

The documents in question are definitely not "Shared" with other users.
What would be causing this and how do I fix it
0
Comment
Question by:J.R. Sitman
[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
5 Comments
 
LVL 34

Expert Comment

by:Norie
ID: 36519198
How are the workbook(s) being closed?

If it's done manually this shouldn't happen but if there's code involved something in the code could be causing problems.
0
 

Author Comment

by:J.R. Sitman
ID: 36519579
manually
0
 
LVL 24

Accepted Solution

by:
Sandeshdubey earned 2000 total points
ID: 36521040
Refer the link for more information on this issue.
http://support.microsoft.com/kb/2018458#appliesto

Also refer the link which discusses the same issue.
http://social.answers.microsoft.com/Forums/en-US/msestart/thread/4fb9906e-a543-419c-9dae-1dd1387df55c

Also let us know the workstaion OS?Is it comming for specific OS ver or all.

0
 
LVL 26

Expert Comment

by:Leon Fester
ID: 36522162
Close all instances of Excel on your machine
Right-click the taskbar and click "Task Manager" or "Start Task Manager"
Under the processes tab look for any instances of excel.exe and "End Task" those items.

To check if the file is open by anybody else you can access the "Computer Manager" on the workstation/server that is hosting that file
Navigate to Shared Folders
Navigate to Open FIles

Any files that are open remotely should be listed there for you to see who is accessing the files.
0
 

Author Comment

by:J.R. Sitman
ID: 36549383
I'll get to this today.  Sorry for the delay.  I'm the only IT for the entire company.  BUSY
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This process allows computer passwords to be managed and secured without using LAPS. This is an improvement on an existing process, enhanced to store password encrypted, instead of clear-text files within SQL
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Suggested Courses

777 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