| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set Excel 2000 to automatically create backup file.
When I make changes and save them via Ctrl+S or File Save, I would like the
previous copy to become a backup copy. Have forgotten how to do this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Set Excel 2000 to automatically create backup file.
Try FileSave As then at top right of Toolbar hit ToolsGeneral Options(or
Options) and you will get a dialog where you select "always create backup". I don't use 2000 but it was this way in 97 and is in 2002 and 2003. Gord Dibben MS Excel MVP On Tue, 6 Mar 2007 16:59:08 -0800, Steve Zed wrote: When I make changes and save them via Ctrl+S or File Save, I would like the previous copy to become a backup copy. Have forgotten how to do this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Set Excel 2000 to automatically create backup file.
Thanks Gord.
Much appreciated, works fine. Steve "Gord Dibben" wrote: Try FileSave As then at top right of Toolbar hit ToolsGeneral Options(or Options) and you will get a dialog where you select "always create backup". I don't use 2000 but it was this way in 97 and is in 2002 and 2003. Gord Dibben MS Excel MVP On Tue, 6 Mar 2007 16:59:08 -0800, Steve Zed wrote: When I make changes and save them via Ctrl+S or File Save, I would like the previous copy to become a backup copy. Have forgotten how to do this. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Set Excel 2000 to automatically create backup file.
Thanks for the feedback.
Now I know 2000 is same as other versions. On Tue, 6 Mar 2007 19:09:13 -0800, Steve Zed wrote: Thanks Gord. Much appreciated, works fine. Steve "Gord Dibben" wrote: Try FileSave As then at top right of Toolbar hit ToolsGeneral Options(or Options) and you will get a dialog where you select "always create backup". I don't use 2000 but it was this way in 97 and is in 2002 and 2003. Gord Dibben MS Excel MVP On Tue, 6 Mar 2007 16:59:08 -0800, Steve Zed wrote: When I make changes and save them via Ctrl+S or File Save, I would like the previous copy to become a backup copy. Have forgotten how to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, I want to create a backup copy whenever I save a file. | Excel Discussion (Misc queries) | |||
| create a separate backup file in excel when exiting | Excel Worksheet Functions | |||
| Excel 2000 cannot save and create temp file | Setting up and Configuration of Excel | |||
| How do I Create backup of excel file in other folder | Excel Discussion (Misc queries) | |||
| can I choose office to create a backup file on another drive? | Setting up and Configuration of Excel | |||
Linear Mode
