Excel - file sharing violation error

Discussion in 'Software' started by rb3bm4, May 24, 2010.

  1. rb3bm4

    rb3bm4 Private E-2

    Problem is I get a “file sharing” violation error when I try to save previously created Excel files. You then get prompted to save to a temporary file. So you have to save as and end up with a gazillion versions of the same file. I recently bought a new laptop and transferred some Excel files from the old one. Using Vista, Excel 2007, and Norton Security on the old machine. Using Windows 7, Excel 2007, and McAfee on the new machine. Searched the internet and this seems to be a common problem. However, lots of variety in terms of cause and solution. At the moment using Excel a lot and this has become a really annoying problem. Thanks, RB
     
    rb3bm4, May 24, 2010
    #1
  2. DavidGP

    DavidGP MajorGeeks Forum Administrator - Grand Pooh-Bah Staff Member

    Hi

    Many Antivirus applications can cause this, so try a quick test and either disable McAfee completly or boot into safe mode (F8 at boot) and try your excel files, add some data and save.

    Does the same happen?

    Are you saving these files on a local HDD or Network HDD?

    Which version of McAfee as while I dont know the app very well these days a thought of mine is to add both *.xls and *.xlsx to the allowable file extentions (if Mcafee has that option) that the scanner will overlook, not great for 99.9% security as macro virii can come in excel files, but if these files are only your own then I dont see the harm.
     
    DavidGP, May 24, 2010
    #2
  3. rb3bm4

    rb3bm4 Private E-2

    Thanks for your reply. Booted in safe mode, opened one of the problem files, and was able to save it about 20 times. McAfee seems to be the problem. I'm saving to my laptop's hard drive. Am using McAfee Security Center; not sure which version. Laptop purchased six months ago so it's recent. Not sure how exclude to Excel files in McAfee but will pursue this and try to do so.
    Best, RB
     
    rb3bm4, May 25, 2010
    #3
  4. rb3bm4

    rb3bm4 Private E-2

    I guess I spoke too soon. I disabled McAfee Security Center. Opened the problem file in Excel, tried to save it, and got the same old file sharing violation. So I guess it's not McAfee. Other suggestions???
     
    rb3bm4, May 25, 2010
    #4
  5. DavidGP

    DavidGP MajorGeeks Forum Administrator - Grand Pooh-Bah Staff Member

    Hi

    To be honest Mcafee is a pain in the butt to accuratly stop in normal mode, if you have the original installer files and your serial code, I would fully uninstall it to check if indeed its the cause in normal mode (with it not happening in Safe Mode its a possible), may need to run the McAfee uninstaller tool to fully remove it and its HERE

    Drastic measures I know but only think I can think of at present thats likely to cause is is a security app.


    Did read a few things posted in Mcafee forums and FAQs and doesnt seem as you can add file exceptions to the application, thats poor IMHO, so give McAfee support a call or email and see what they suggest as a workaround to this, espeically if you do uninstall and test and the test is ok then re-install and the excel files dont save properly.
     
    DavidGP, May 25, 2010
    #5
  6. rb3bm4

    rb3bm4 Private E-2

    Am using McAfee Security Center and it came pre-installed on the laptop. Will find the disks, uninstall, and check the problem. Two other things. First, seems to be a lot written about this problem upon further research and no real consensus on cause and solution. To summarize, the MS people blame the computer security people and vice versa. Did find something which suggests it really is an MS problem. See:
    http://support.microsoft.com/kb/970950/en-us
    Am wondering what you think about the plausibility of this solution. Second, McAfee, Norton, et al seem to be a pain for a variety of reasons and this isn’t the first problem I’ve run into using them. Am wondering what the alternatives are to these bundled big name products. Thanks again, RB
     
    rb3bm4, May 26, 2010
    #6
  7. plodr

    plodr MajorGeek Super Extraordinaire Moderator Staff Member

    I didn't accept the free McAfee offered by my ISP, Comcast and when I bought a new computer with Norton trial installed, I nuked it off.
    The best way, from personal experience, is to install Revo Uninstaller. It uses the programs own uninstaller, if there is one, then also does the additional step of finding all the bits and pieces in the registry. It offers you the ability to remove those unwanted registry entries too.

    Hint: keep the default setting in Revo (moderate). Never hit the delete all button when presented with the registry entries. You need to select only items in bold because they refer to the software. If you delete all, you will have crippled the registry by removing necessary items and quite possibly be unable to boot up the computer.

    As far as good products, the big three free ones are usually mentioned, Avast, Avira and AVG. You will probably find numerous threads here on who likes and dislikes each of the three and why.
     
    plodr, May 26, 2010
    #7

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds