?
Solved

Excel cannot re-open it because of a sharing violation

Posted on 2011-09-11
5
Medium Priority
?
5,593 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 36

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

571 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