Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Excel 2007- can't get it to automatically make backups

Please don't multi-post, you have be told how to set the file to make a
back-up file already.

JoeZ wrote:
With Word, I can to Options/Advanced/Save and choose to Always create backup
copy. Then, every time I resave a Word 2007 doc, I get the backup with a
.wbk file extension.

I just can't figure out how to do the same with Excel.

There is no comparable Options/Advanced/Save choices. I do see in Word the
AutoRecover option in Options/Save- though there is something weird about
that because it has for a default AutoRecover file location:
C:\Users\Joseph\AppData\Roaming\Microsoft\Excel\ but I can't find the
AppData folder unless it's hidden.

In the Excel help file- it has a description of how to "Automatically save a
backup copy of a workbook" but instead of describing how to do that- it
describes the AutoRecover feature. But, that's not what I want- I want to
see the actual backup file get created each time I resave an Excel file-
just like those Word .wbk files.

I'm obviously doing something stupid.

Joe


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
make excel automatically add a decimal Darrell Eddy Excel Worksheet Functions 1 March 20th 08 05:32 PM
Excel backups Allore Excel Discussion (Misc queries) 11 January 26th 06 05:30 AM
How do I do automatic backups in excel xp? lettbalt Excel Discussion (Misc queries) 0 June 8th 05 05:21 PM
How do I do automatic backups in excel xp? Peo Sjoblom Excel Discussion (Misc queries) 0 June 8th 05 05:21 PM
can excel automatically make 1/2 the smaller1/2 - Like in an ad. Staci Excel Discussion (Misc queries) 2 March 7th 05 11:51 PM


All times are GMT +1. The time now is 05:25 PM.

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"