Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default Where does Save As Automatic Backup save its files?

I understand that you can go to File Save As General & check the Always
create backup box to create backups.

Where are these files stored? Can you change the location or naming
convention so you can ensure previous backup files are not overwritten?

Is this a full backup? Or only the changes?

Thanks,
--
JoAnn
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Where does Save As Automatic Backup save its files?

The backup files are stored in the same folder as the original.

If the original file is named book1.xls, then the backup will be named:
backup of book1.xlk

The location is determined by excel--not the user.

And excel is different from word. You save the complete file. There are no
"fast" saves.


JoAnn wrote:

I understand that you can go to File Save As General & check the Always
create backup box to create backups.

Where are these files stored? Can you change the location or naming
convention so you can ensure previous backup files are not overwritten?

Is this a full backup? Or only the changes?

Thanks,
--
JoAnn


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Where does Save As Automatic Backup save its files?

Backups are saved to the folder that the original file is opened from.

Previous backups are overwritten.

Full backup always one version behind your current save.


Gord Dibben MS Excel MVP



On Thu, 3 Apr 2008 11:46:00 -0700, JoAnn
wrote:

I understand that you can go to File Save As General & check the Always
create backup box to create backups.

Where are these files stored? Can you change the location or naming
convention so you can ensure previous backup files are not overwritten?

Is this a full backup? Or only the changes?

Thanks,


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default Where does Save As Automatic Backup save its files?

thank you both!
--
JoAnn


"Gord Dibben" wrote:

Backups are saved to the folder that the original file is opened from.

Previous backups are overwritten.

Full backup always one version behind your current save.


Gord Dibben MS Excel MVP



On Thu, 3 Apr 2008 11:46:00 -0700, JoAnn
wrote:

I understand that you can go to File Save As General & check the Always
create backup box to create backups.

Where are these files stored? Can you change the location or naming
convention so you can ensure previous backup files are not overwritten?

Is this a full backup? Or only the changes?

Thanks,



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
Creating Automatic Backup Files on another drive helvetik New Users to Excel 3 February 23rd 07 09:04 PM
save a backup copy in different folder GT Excel Discussion (Misc queries) 3 May 11th 06 07:36 PM
Turn on automatic backup files Sarge Excel Discussion (Misc queries) 2 June 8th 05 07:12 PM
Why don't my latest changes get save in my backup lonsar37 Excel Worksheet Functions 2 May 12th 05 08:07 AM
How do i save backup copy in a different folder mekraj Excel Discussion (Misc queries) 3 December 17th 04 08:33 PM


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

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

About Us

"It's about Microsoft Excel"