Have you ever received the notification ‘Sharing Violation’ when saving a Microsoft Excel workbook? You, me and countless other people!
I’ve searched around and found lengthy discussions and intricate solutions and options for this problem, yet the answer is really quite easy and doesn’t require any technical stuff.
MS Office 2010 comes complete with its own ‘one-click’ diagnostic tool. After ten minutes of frustration trying to save a workbook and receiving the ‘sharing violation warning’ that prevents saving of the spreadsheet, I opened the repair tool and it quickly located and fixed the error (in this case an errant, self-induced printer setting).
Mastering Microsoft Excel – Click For More Details
If you are running MS Office 2010then here’s how:
(Office 2007 also suffers from this same ‘sharing violation’ error. The 2007 onboard diagnostics apparently does the same job – I don’t know the actual process though, having converted directly from Office 2003 to 2010)
Microsoft Office 2010 Users
Select ‘File’ from the Main Menu
Select ‘Info’ from the Sidebar
Click on the 2nd box down ‘Check for Issues’ and select the first option ‘Inspect Document’
Make sure all the boxes are checked then click ‘inspect’
If it finds an issue, it will ‘Flag’ it for you and give you the option to ‘fix’ the issue.
It worked for me in a nanosecond and re-inspecting the document found no further problems.
The document could then be saved and no more annoying ‘sharing violation’ pop-up!
Was this post useful? 
