How do you turn off automatic "save a copy" in Excel
 

I absolutely abhor the fact that excel saves a copy rather than automatically
saves to the original document. Does anyone know how to turn off the "save a
copy" feature and to have Excel automatically save to the original document.

Cecilia,

I think you're referring to Autorecover (Tools - Options - Save tab). To
automatically save to the original file, use Autosave. It's in Tools -
Addins. There are disadvantages to Autosave. Instead, being in the habit
of saving at appropriate times is a good technique to master. Consider
versions (do Save as, "Myfile-2.xls", "Myfile-3.xls", etc. Then remove the
old ones when you're sure you won't need them.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Cecilia Quinn Dean" <Cecilia Quinn wrote in
message ...
I absolutely abhor the fact that excel saves a copy rather than
automatically
saves to the original document. Does anyone know how to turn off the
"save a
copy" feature and to have Excel automatically save to the original
document.

Cecilia

Is this the message you are getting?

"The file 'filename.xls' may have been changed by another
user since you last saved it. In that case, what do you
want to do? ()Save a copy () Overwrite changes."

If that is the case have a look at this KB Article.....

"The file may have been changed..." error when you save work*book to network
server in Excel 2002

http://support.microsoft.com/d*efault.aspx?kbid=324491

Myrna Larson also reported that she got this error when opening a workspace
(*.xlw) file.

Opening the workbooks individually solved the problem.


Gord Dibben Excel MVP





On Sun, 22 May 2005 09:59:16 -0700, Cecilia Quinn Dean <Cecilia Quinn
wrote:

I absolutely abhor the fact that excel saves a copy rather than automatically
saves to the original document. Does anyone know how to turn off the "save a
copy" feature and to have Excel automatically save to the original document.