[Last Call] Learn how to a build a cloud-first strategyRegister Now


Have to change name of excel file to save

Posted on 2011-04-21
Medium Priority
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

TommySzalapski earned 2000 total points
ID: 35442800
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

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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.

834 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