Solved

Excel cannot re-open it because of a sharing violation

Posted on 2011-09-11
5
3,580 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
Comment Utility
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
Comment Utility
manually
0
 
LVL 24

Accepted Solution

by:
Sandeshdubey earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
I'll get to this today.  Sorry for the delay.  I'm the only IT for the entire company.  BUSY
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Resolve DNS query failed errors for Exchange
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

762 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

9 Experts available now in Live!

Get 1:1 Help Now