{ 17 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.

Discussion


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

  1. [...] 2007 workbook that’s stored on a network drive.  The issue is discussed in this article Microsoft Excel 2007 Sharing Violation Error When Saving. This download is provided free and without any guarantee that it will solve your problems.  You [...]

  2. 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?

  3. 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?

                Thanks

  4. 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.

  5. Preeti Singh says:

    thanks…..succesfully

  6. harrezz says:

    thx it works perfectly

  7. 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 ……????????????

  8. […] MS Excel: Sharing Violation error when saving (SOLVED) – This error occurs when you launch attempt to save an Excel workbook under various different circumstances. This solution has been specifcally tested on Microsoft …… […]

Leave a Reply