Solved

Excel cannot re-open it because of a sharing violation

Posted on 2011-09-11
5
3,841 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
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:J.R. Sitman
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: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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Synchronize a new Active Directory domain with an existing Office 365 tenant
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

772 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