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

P

p

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
 
C

carlo

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

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
 
J

Jim May

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,,
 
D

David Biddulph

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.
 
Top