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

On Nov 22, 10:59 am, p wrote:
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

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

"p" wrote:

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

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.
--
David Biddulph

"p" wrote in message
...
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