sharing violations when saving network shared Excel files

Good morning,

I have recently run into an issue with sharing violations when saving network shared Excel files. I get an error as follows

"The document was saved successfully, but Excel cannot re-open it because of a sharing violation. Please close the document and try to open it again"

I can save to non shared files no problem and if I copy the shared workbook to the local hard drive it saves no problem, but as soon as a file is shared on the network I get the error.  Many other computers and laptops access and save this Excel spreadsheet without an issue (with the same user logon) all running XP but this is the first Windows 7 machine to be introduced to the environment. I have searched high and low on the net for solutions but none seem to work.

I have disabled Windows Search, file caching, the details pane. I have uninstalled Symantec. Converted the file to various versions of Excel (original is Excel 97, has been converted to 2003, 2007, and 2010 formats. I have checked all permissions on the file and the folder it resides in. I even uninstalled Office 2010 and installed Office 2003 with the same results. Any ideas would be very much appreciated. I love Windows XP but lets face it, It's not going to be around forever and new hardware comes standard with Win 7 these days. I really need to make this work.  

As a side note - When using Excel 2010 to open the Excel 97 file it asks for the password to be typed in 3 times?????? In my testing as soon as I converted it to 2010 it only asked once. I know this is a different issue but I thought I would bring it up in case anyone has run into this as well.

 

Environment:

Network - Novell Open Enterprise Server 6.5 SP8

Windows 7 Professional 64bit (Fully updated)

Novell Client 2 SP1 for Windows 7

Microsoft Office 2010 Home and Business

Symantec Endpoint Protection v 11.0.5

 

Thanks in advance to anyone taking the time to read this.

November 30th, 2011 4:34pm

Hi,

This problem probably more Sharing Violation related, You can refer to this KB article:

"Sharing Violation error when saving an Office 2007 document in Windows 7"

http://support.microsoft.com/kb/2018458

To reduce the frequency of the issue you can use the following Workarounds:

  • Move the files off of the desktop and out of Folders located on the Desktop
  • In Windows Explorer turn off the Details Pane
    • Unselect 'Details Pane' on the Organize menu under Layout.
  • Close the Windows Explorer window which contains the files you are working with.

 Note: The article applies to Office 2007 but the same applies to Office 2010 as well

And also disable Anti-virus program(Norton, McAfee) test this issue.

 

Best regards

Free Windows Admin Tool Kit Click here and download it now
December 2nd, 2011 5:25am

William Zhou CHN,

Your answer does not resolve the issue.

Rowan

June 6th, 2012 6:46am

Passing on this very simple advice from another and it WORKS

Hector Parra replied on December 5, 2011
Try disabling the index option on the folder.
Right click on the affected folder (where the file giving the error is located), choose properties. Click the "advanced" button near the bottom. Uncheck the "allow indexing" box.


Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 5:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics