Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Workbook at a certain time jswalsh33 Excel Worksheet Functions 2 February 20th 10 01:12 PM
Eliminate macro warning when you open a workbook Karlene Excel Discussion (Misc queries) 1 January 13th 10 05:45 PM
Every second time i open Excel, it displays the document recovery pane Paliente Excel Discussion (Misc queries) 3 September 14th 05 01:53 PM
can you get a backup copy of a document in Excel? Peggy Allen Excel Discussion (Misc queries) 1 February 23rd 05 09:51 PM
How do I make a backup file of my excel document? Starrystella Excel Discussion (Misc queries) 1 January 7th 05 07:43 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"