ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Eliminate creation of backup document every time I open workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/257476-eliminate-creation-backup-document-every-time-i-open-workbook.html)

Judy in Orlando

Eliminate creation of backup document every time I open workbook?
 
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

Dave Peterson

Eliminate creation of backup document every time I open workbook?
 
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.

Judy in Orlando wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 02:19 AM.

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