Excel save errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All of a sudden, ALL of my spreadsheets will NOT save after being opened -
whether I change them or not!

I get an error telling me that the file can't be saved because of a sharing
violation.

The file isNOT shared!

I am prompted to save the file with a different name.

If I do this then close the original file and open the new file name and
select Save As and highlight the original name, I am informed that the file
may have been changed by another user since I last saved it and haqve 2
options - Save a Copy (default choice) and overwrite the changes. If I
choose the latter (logically), I get the error message Document not saved.

How do I stop this annoying and time-comsuming mess?
 
Hi Bruce,
All of a sudden, ALL of my spreadsheets will NOT save after being opened -
whether I change them or not!

I get an error telling me that the file can't be saved because of a sharing
violation.

The file isNOT shared!
Click to expand...

There is a number of things that may be causing this.

1. Anti virus software: it might still be scanning the temporary file Excel
creates during the save process when Excel tries to rename the file (normally
that would cause Excel to produce files looking like 21313455.xls)

Resolve this by changing settings of your anti virus software

2. You have no delete permissions on the folder to which you are saving

Try deleting a file from the folder to see if this may be the case

3. You've experienced a crash recently and a hidden instance of Excel is still
about, which has one or more of these files still open

Close Excel. Then hit control-alt-delete and see in the processes if any
Excel.exe is/are still there. End those processes.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
Back
Top