Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
In previous versions of office, I could set a file to make a backup when I
saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
AutoRecover is not "Automatic Backup" and the AutoRecover file is
deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
Understood, but is there no way in Excel 2007 of setting a file to make a
backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
I don't have Excel 2007, but
http://office.microsoft.com/en-us/ex...SaveBackupCopy suggests it's similar to 2003 in that its's one of the options uder "Save As": "Automatically save a backup copy of a workbook Click the Microsoft Office Button , and then point to the arrow next to Save As. Click the arrow next to Tools, and then click General Options. Select the Always create backup check box. " -- David Biddulph "Bruce" wrote in message ... Understood, but is there no way in Excel 2007 of setting a file to make a backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
Unfortunately excel 2007 does not appear to have this option under "save as"
but I'll look further, thanks. "David Biddulph" wrote: I don't have Excel 2007, but http://office.microsoft.com/en-us/ex...SaveBackupCopy suggests it's similar to 2003 in that its's one of the options uder "Save As": "Automatically save a backup copy of a workbook Click the Microsoft Office Button , and then point to the arrow next to Save As. Click the arrow next to Tools, and then click General Options. Select the Always create backup check box. " -- David Biddulph "Bruce" wrote in message ... Understood, but is there no way in Excel 2007 of setting a file to make a backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
I seem to have found it at last, though the steps were not quite the same as
described in the document you quoted. Many thanks for your help. "David Biddulph" wrote: I don't have Excel 2007, but http://office.microsoft.com/en-us/ex...SaveBackupCopy suggests it's similar to 2003 in that its's one of the options uder "Save As": "Automatically save a backup copy of a workbook Click the Microsoft Office Button , and then point to the arrow next to Save As. Click the arrow next to Tools, and then click General Options. Select the Always create backup check box. " -- David Biddulph "Bruce" wrote in message ... Understood, but is there no way in Excel 2007 of setting a file to make a backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
Mind sharing? I have not seen anything other than the AutoRecover for 2007.
Bruce wrote: I seem to have found it at last, though the steps were not quite the same as described in the document you quoted. Many thanks for your help. "David Biddulph" wrote: I don't have Excel 2007, but http://office.microsoft.com/en-us/ex...SaveBackupCopy suggests it's similar to 2003 in that its's one of the options uder "Save As": "Automatically save a backup copy of a workbook Click the Microsoft Office Button , and then point to the arrow next to Save As. Click the arrow next to Tools, and then click General Options. Select the Always create backup check box. " -- David Biddulph "Bruce" wrote in message ... Understood, but is there no way in Excel 2007 of setting a file to make a backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
I feel very much a novice in the company of experts and you must forgive me
if I do not understand you. If you mean how did I find the way to force a backup in excel 2007; it was to click the "save as" when the file was open, then choose "other formats", then click "tools" at the bottom of that pane, then choose "general options", then tick "always create backup" and, if you wish, fill in password boxes etc. Probably I am telling a pro something he knows perfectly well already. In that case, sorry! "Bob I" wrote: Mind sharing? I have not seen anything other than the AutoRecover for 2007. Bruce wrote: I seem to have found it at last, though the steps were not quite the same as described in the document you quoted. Many thanks for your help. "David Biddulph" wrote: I don't have Excel 2007, but http://office.microsoft.com/en-us/ex...SaveBackupCopy suggests it's similar to 2003 in that its's one of the options uder "Save As": "Automatically save a backup copy of a workbook Click the Microsoft Office Button , and then point to the arrow next to Save As. Click the arrow next to Tools, and then click General Options. Select the Always create backup check box. " -- David Biddulph "Bruce" wrote in message ... Understood, but is there no way in Excel 2007 of setting a file to make a backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backup of excel 2007 files.
Thank you. I certainly don't know nearly as much about Excel 2007 as
most here. Bruce wrote: I feel very much a novice in the company of experts and you must forgive me if I do not understand you. If you mean how did I find the way to force a backup in excel 2007; it was to click the "save as" when the file was open, then choose "other formats", then click "tools" at the bottom of that pane, then choose "general options", then tick "always create backup" and, if you wish, fill in password boxes etc. Probably I am telling a pro something he knows perfectly well already. In that case, sorry! "Bob I" wrote: Mind sharing? I have not seen anything other than the AutoRecover for 2007. Bruce wrote: I seem to have found it at last, though the steps were not quite the same as described in the document you quoted. Many thanks for your help. "David Biddulph" wrote: I don't have Excel 2007, but http://office.microsoft.com/en-us/ex...SaveBackupCopy suggests it's similar to 2003 in that its's one of the options uder "Save As": "Automatically save a backup copy of a workbook Click the Microsoft Office Button , and then point to the arrow next to Save As. Click the arrow next to Tools, and then click General Options. Select the Always create backup check box. " -- David Biddulph "Bruce" wrote in message ... Understood, but is there no way in Excel 2007 of setting a file to make a backup when it is closed (in the same folder as the original file) as there was in earlier versions of Excel? "Bob I" wrote: AutoRecover is not "Automatic Backup" and the AutoRecover file is deleted when the Excel file is closed. Bruce wrote: In previous versions of office, I could set a file to make a backup when I saved it. I cannot find a way to do this with Excel 2007 and though I have the automatic backup set to save every ten minutes, my automatic backup folder AppData\Roaming\Microsoft\Excel\ is always empty. Any solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Backup files | Excel Discussion (Misc queries) | |||
Using a hyperlink to backup Excel files | Excel Worksheet Functions | |||
How do I disable backup files from Excel Queries? | Excel Discussion (Misc queries) | |||
Excel 2003 Backup Files | Excel Discussion (Misc queries) | |||
Excel Backup Files, shared Network | Excel Discussion (Misc queries) |