We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Have to change name of excel file to save

Penncomp asked
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.  
Watch Question

Awarded 2010
Top Expert 2013
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
TracyVBA Developer

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.