{ 20 Intelligent Comments }

MS Excel: Sharing Violation Error When Saving Excel Workbook

Microsoft Excel 2007 Sharing Violation Save Error

Microsoft Office Excel Error: Your changes could not be saved to ‘filename.xls’ because of a sharing violation. Try saving to a different file.

This error occurs when you launch attempt to save an Excel workbook under various different circumstances.

This solution has been specifcally tested on Microsoft Excel 2007 running on Windows 7.

The Excel file that is open at the time is stored on a network shared drive located on a Windows 2003 server.

It is likely that you will also receive the following error in addition to the sharing violation error:

The file you are trying to open, ‘filename.xls’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file .  Do you want to open the file now?

It is thought that this error is being caused by a bug in the Excel 2007 Shell Extension msoshext.dll and only applies to MS Office SP1 and SP2 users.

Solution 1: Download & Apply Hotfix (office-kb982125-fullfile-x86-glb)

  1. Download the official Microsoft hotfix here
  2. Close all Microsoft Office products including Excel, Outlook, Word, Access and Powerpoint.
  3. Double click the office-kb982125-fullfile-x86-glb.exe file that you downloaded in step 1 and follow the wizard to install.
  4. Restart Windows.


Wow, 20 Comments! We've got a conversation going now. Join the discussion below!

  1. Aruna says:

    I have downloaded and installed sharing violation Hotfix but the error message appeared ” The expected version of the product was not found on the system” hopeless…………..

    1. ian says:

      Have you checked if you’re running the version of the product mentioned on your system?

  2. Andy says:

    I get the same problem with Excel 2010 when running it against large workbooks running on Google Drive.

    1. Rosco says:

      Hi Andy…
      Google Drive is quite new and because it’s a service that syncs your files up and down it’s probable that this error is appearing correctly – i.e. it is an actual sharing violation due to Google Drive locking the file during a sync. It’s worth investigating.

      1. Andy says:

        What appears to be happening is Google drive locks the temporary file during the save. However, once the sharing violation occurs I am unable to save the file at all…even to another drive outside Google drive and even if I suspend Google drive. It does something to lock the original file in such a way that cannot save and I lose all my changes.

        1. Rosco says:

          What version of Office are you using? Are you using Windows or Mac?
          is this reproduceable? i.e. does it happen every time?

          1. Andy says:

            Excel 2010 on Windows 7. Repeats consistently with a large workbook (bigger than 10 Meg).

            1. Rosco says:

              I simply can’t reproduce this problem Andy. I’ve tried the config you’ve said, Windows 7, Excel 2010, Google Drive, spreadsheet over 10MB (tried both XLS and XLSX). I can see the temp file getting created when I save and even if I repeatedly save quickly it doesn’t crack.

              Do you by change have the same file open on another PC somewhere?

              1. Andy says:

                Thanks for trying Rosco. I get the error consistently. I’ve just decided to use dropbox for that file…a second best for my needs, but so far I am not getting the same errors. And, no, it was not open on any other computer. I was just using Google Drive as a backup mechanism.

              2. KG says:

                Hi Rosco

                I’m having the exact same problem – but I’m not keen to move to Dropbox. Did you by any chance try and solve this problem?


  3. Sten says:

    I have the same problem, and it was caused by AVG anti-virus. Tried all the suggestions, and it stopped after I disabled the AVG anti-virus. After that I changed the Anti-virus to Avira and the problem seem to stop.

    1. Andy says:

      Thanks Sten. I am using Microsoft Security Essentials and that may be the problem. On the other hand Google Drive just seems less stable than Dropbox (GD shuts down pretty frequently) so maybe they will improve with time.

  4. Preeti Singh says:


  5. harrezz says:

    thx it works perfectly

  6. Inge says:

    This error message is driving me nuts! I have 2 PC’s at home which share files. Password_Protected.xlsm in question is 10.2KB

    From what I’ve read, this problem is NOT unique to my environment!
    WIndows 7, Office 2010, .xlsm with macros and 6-character SMALL password protection for file and macros.

    My work-around:
    – Made sure this is the ONLY open .xlsm
    – I save every 2nd or 3rd iteration!
    – Save works 8-10 times or NOT at all, even the first time
    – Open a new TEMP.xls and copy the changes there as a “hold”
    – Only solution is to ABORT everything in the .xlsm,
    leave TEMP.xls open
    – Open the file.xlsm again
    – Enter the change again by copying back from Temp.xls
    – Save again
    * Go on with life and get ready to safe the next change entry!!!

    * I’ve been reading for two (2) weeks and none of the
    suggestions I found have worked for me.

    Since I save the exact same file in the exact same
    folder with the exact same name ……????????????

  7. Nguyen Tien Dat says:

    I think every body no need to be worry, just update window and restart then everything will runs normally. That’s best way to solve this case.

    1. GBlanda says:

      Didn’t work for me.

  8. GBlanda says:

    I cannot save some xlsx or pptx 2010 files. The error message says a sharing violation. I can save to a subfolder, to a different name in the current drive, or to an older xls or ppt version. Just can’t save to the current name or rename another file to that name. I am running W10. Have run updates manually and am told that W10 and Office 2010 are up to date. An Office 2010 security update ran yesterday which is when I started having problems. Just sayin’

  9. Mark says:

    I’ve just started having this problem in the last month or so. I’ve been saving a rather large Excel file to my Google Drive folder without any issues, until this happened. Has anyone made any headway in solving???

    1. BertusZ says:

      When trying to save an excel document (office 2010) I also received privacy warning message:
      “This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the Document Inspector.”

      This could be fixed as follows:
      in FILE tab; options; trust centre; trust centre settings; privacy options
      Uncheck: Remove personal information from file properties on save.
      Then save the setting with OK and again OK.
      Since then my documents could be saved normally again

Leave a Reply