Solved

Excel cannot re-open it because of a sharing violation

Posted on 2011-09-11
5
3,714 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:jrsitman
5 Comments
 
LVL 33

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:jrsitman
ID: 36519579
manually
0
 
LVL 24

Accepted Solution

by:
Sandeshdubey earned 500 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:jrsitman
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Synchronize a new Active Directory domain with an existing Office 365 tenant
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
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.

910 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

16 Experts available now in Live!

Get 1:1 Help Now