ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   stop my speadsheet from creating an automatic backup copy (https://www.excelbanter.com/excel-discussion-misc-queries/26671-stop-my-speadsheet-creating-automatic-backup-copy.html)

lggallo

stop my speadsheet from creating an automatic backup copy
 
I have a spreadsheet I work with on a daily basis. Every morning I access
it, there is a backup copy of this spreadsheet in my folder where I keep this
spreadsheet. I want this to stop. thanks! Linda G.

Dave Peterson

If the name of the workbook has a .xlk extension, then try this:

File|SaveAs|Click on Tools|General Options|Uncheck "always create backup"

(This is the path for xl2002+. For xl2k, I think it was just "options"--not
"general Options".

lggallo wrote:

I have a spreadsheet I work with on a daily basis. Every morning I access
it, there is a backup copy of this spreadsheet in my folder where I keep this
spreadsheet. I want this to stop. thanks! Linda G.


--

Dave Peterson

Gord Dibben

FileSave AsToolsGeneral Options.

Uncheck "always create a backup".

Save the file.


Gord Dibben Excel MVP

On Wed, 18 May 2005 10:16:06 -0700, "lggallo"
wrote:

I have a spreadsheet I work with on a daily basis. Every morning I access
it, there is a backup copy of this spreadsheet in my folder where I keep this
spreadsheet. I want this to stop. thanks! Linda G.



lggallo

Thanks! It worked just fine and now I'm a happy camper. Linda G

"Gord Dibben" wrote:

FileSave AsToolsGeneral Options.

Uncheck "always create a backup".

Save the file.


Gord Dibben Excel MVP

On Wed, 18 May 2005 10:16:06 -0700, "lggallo"
wrote:

I have a spreadsheet I work with on a daily basis. Every morning I access
it, there is a backup copy of this spreadsheet in my folder where I keep this
spreadsheet. I want this to stop. thanks! Linda G.





All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com