Everytime i close an excel file, it creates a new backup file

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

Guest

Everytime i close an excel file, it creates a new backup file named the
original file name but excel adds the word backup to it
 
Everytime i close an excel file, it creates a new backup file named the
original file name but excel adds the word backup to it
Click to expand...

Go to File --> save as

in the upper left corner you should see "tools"
there you can click on "general options"
uncheck: "create backup"
and save your sheet again.

hth

Carlo
 
While in the Worksheet File - press Alt+F11; In the VBE Explorer Window look
for the Thisworkbook module under your Project or File Name.. Doble Click
This workbook -- you probably have a Before Close Macro set up. You can
comment out each row by adding the " ' " (without the quotes in the first
position of each line)..
HTH,,
 
Congratulations! Very wise!

Those who fail to use the option to keep a backup are those who come to this
group with plaintive (but fruitless) questions as to how they can retrieve
their lost data when they have inadvertently saved over their previous work.

Stick with your current options.
 
Back
Top