Sharing Violation when saving local files - Excel 2007

Question

Greetings earthlings. My boss has a problem with saving files in Excel 2007. Problem: Excel 2007 can only save to a local file once. Every new revision of any file must be saved with a different name. Error message: is in Norwegian. It's the equivalent to 'Your changes could not be saved to [file name] because of sharing violation. Try saving to a different file.' Error description: It does not seem to be LAN related, the file is attempted saved in 'my documents' locally. The file doesn't need to contain macros, it will do the same if it only containts 'qwerty'. Excel does NOT offer to save a temporary file, like some report when having sharing violations over LAN. The user has to regularly go over the folder to delete duplicates/older versions. Setup: New Dell laptop with XP and Office 2007. LAN setup: It's connected to internet via a LAN but there's no common file server or file sharing what so ever over the network. In other words this seems to be a different case than most of the 'sharing violation' threads than I've found. Has anyone experienced something like this when saving to local files? Could this be a result of i.e. the antivirus program monitoring the file?

abach · Answer

Let's see if an add-in could be causing this. Click Start, Run and type the following   excel /s   This starts Excel in Safe mode with no add-ins. Try saving the file. If it works, you'll need to determine which add-in is causing the problem. To view add-ins, Office Button, Excel Options button, Add-ins. If you're not sure what to remove, let me know.   Also, and I know this sounds strange, you may need to un-install, then re-install, your printer driver.

djbet · Answer

Thank you for the advice. I will check out both. Maybe this can be attributed to a virtual printer driver... ...He will, of course, not let me anywhere near his machine until tomorrow.

Message Edited by djbet on 12-20-2007 02:30 PM

djbet · Answer

It seems this problem is caused by Comodo Antivirus hogging the file when Excel tries to write to it. http://forums.comodo.com/help_for_comodo_antivirus/excel_2007_will_not_save_with_av_program_running-t16690.0.html

Productivity Software

Was this post helpful?