Have to change name of excel file to save

Posted on 2011-04-21
Last Modified: 2012-05-11
I have an issue with a excel on office 2007 whereby the person has to change the name of the file each time, after making a change,  or it will not allow him to open it.  It give message ‘  the document was saved successfully but excel  cannot reopen it because of a sharing violation.  Please close the document and try to open it again. ‘ when trying to open after making a change if he does not change file name.  have verified that it is not a shared document because when you go to review - share workbook, the allow changes by more than one user at same time is not checked .  Also verified that it is independent of whether it’s saved at network or on desktop(happens at both places).  I disabled and enabled the trend antivirus and it appeared to work for a while(I saved two different documents with changes as same name and it opened fine on both documents - even after av was re-enabled).  But it seems to be happening again.  Wondering if there is a third party program that could be doing this perhaps or a patch.  
Question by:Penncomp
    LVL 37

    Accepted Solution

    If a third party thing is doing it, it will be in the add-ins. You could disable all add-ins and try again.
    I would also try to enable sharing (check the allow changes by multiple users box) then save it. Then open it and turn sharing back off and save it again. It's weird but that fixes a lot of things.

    Reboot too if you haven't.
    LVL 24

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Title # Comments Views Activity
    Excel - Clone tables or sheet to another work book. 19 60
    Time Clock in Excel issues 5 26
    VBA exception error 5 22
    Search Box 13 21
    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now