Eliminate creation of backup document every time I open workbook?

J

Judy in Orlando

How do I stop the creation of a 'backup' document every time I open a
workbook? I have one document that creates a new backup automatically each
time I open the workbook, but that is not needed. I don't know if there is a
macro code I need to turn off to prevent this happening~

Thank you
 
D

Dave Peterson

Open your troublesome workbook
Show the File|SaveAs dialog
Click on Tools|General Options|Uncheck "always create backup"
and continue your save to overwrite that file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I stop PERSONAL.XLSB from showing every time XL opens? 1
When sharing, can I force an Excel document to open in a certain view? 0
Personal Macro Workbook 1
automatic backup? 2007 version 3
Workbook does not open by default in Excel 2007 2
Eliminate macro warning when you open a workbook 1
macro to display message,when open workbook 7
Shared Workbook creating Backup when saved? 1

Top