 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Excel 2007 Bug .XLK Auto Recovery
Auto Recovery is suppose to save a temp file to C:\Documents and Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel Options to save the Auto Recovery files in that location. However, when I close an Excel 2007 file (that I've saved in My Documents), there is an extra file (in My Documents) with a "Back of" prefix followed by the filename. Three issues: 1. It's not temporary, 2. It's not in the correct location and 3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to work as advertized. Thanks!  SignatureJohn The "Back of" file has nothing to do with Excel's auto recovery feature. Auto recovery files are saved by Excel with some jibberish name (ending in XAR) and they are only useable by Excel itself when it deems necessary, i.e., after a crash. I don't know where the file you have came from. SignatureJim > Auto Recovery is suppose to save a temp file to C:\Documents and > Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel [quoted text clipped - 9 lines] > > Thanks! Thanks, Jim. First, I want to correct my typo. I should have said "Backup of" instead of "Back of". But I still have the dilema. I see the .XAR temporary file in the correct location and Excel 2007 removes it when I close Excel. However, can anyone tell me how to stop Excel from creating an additional file (same name as original) with the "Backup of" prefix in My Documents? SignatureJohn > The "Back of" file has nothing to do with Excel's auto recovery feature. > Auto recovery files are saved by Excel with some jibberish name (ending in [quoted text clipped - 14 lines] > > > > Thanks! >>However, can anyone tell me how to stop Excel from creating an additional >>file (same name as original) with the "Backup of" prefix in My Documents? With the problem workbook active, open the File, Save As dialog. Then open General Options from the Tools menu. Uncheck "Always create backup". I think this has to be done individually for each workbook in which it has been set. SignatureJim | Thanks, Jim. | [quoted text clipped - 24 lines] | > > | > > Thanks! I don't believe it; it worked! Thanks! Microsoft, If you're monitoring this newsgroup, please fix Excel 2007. Users shouldn't have to do this on some of their Excel files. Talk to the Word and PowerPoint teams. This only happens in Excel. SignatureJohn > >>However, can anyone tell me how to stop Excel from creating an additional > >>file (same name as original) with the "Backup of" prefix in My Documents? [quoted text clipped - 42 lines] > | > > > | > > Thanks! Every version of Excel I have worked with back to Excel 5.0 required you to follow Jim's steps to always create a backup. Gord Dibben MS Excel MVP >I don't believe it; it worked! Thanks! > >Microsoft, >If you're monitoring this newsgroup, please fix Excel 2007. Users shouldn't >have to do this on some of their Excel files. Talk to the Word and PowerPoint >teams. This only happens in Excel. The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .XLK) which is one more than I think we need, especially when one (.XLK) never goes away. SignatureJohn > Every version of Excel I have worked with back to Excel 5.0 required you to > follow Jim's steps to always create a backup. [quoted text clipped - 7 lines] > >have to do this on some of their Excel files. Talk to the Word and PowerPoint > >teams. This only happens in Excel. The .xar file is used for AutoRecovery. You shouldn't depend on it being there as a backup. It's created just in case excel crashes (or windows crashes). It should be deleted if the original workbook closes without incident. If there's a crash, you should see a prompt the next time you open excel that will allow you to recover your work. > The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .XLK) > which is one more than I think we need, especially when one (.XLK) never goes [quoted text clipped - 13 lines] > > >have to do this on some of their Excel files. Talk to the Word and PowerPoint > > >teams. This only happens in Excel. SignatureDave Peterson I don't depend on it as a backup. I manually save my work every 15 minutes or so. We also have tape backups on our server and, if it is very important, I make a extra folder for my extra backup file. What I don't like is that Excel 2007 SOMETIMES decides that I want a backup (.XLK) and saves it where my original file is saved. It clutters the folder. SignatureJohn > The .xar file is used for AutoRecovery. You shouldn't depend on it being there > as a backup. [quoted text clipped - 21 lines] > > > >have to do this on some of their Excel files. Talk to the Word and PowerPoint > > > >teams. This only happens in Excel. Jim told you how you can turn off the creation of the backups. > I don't depend on it as a backup. I manually save my work every 15 minutes or > so. We also have tape backups on our server and, if it is very important, I [quoted text clipped - 33 lines] > > > > Dave Peterson SignatureDave Peterson Yes, and I thanked him for it. My issue is with Microsoft Excel 2007 making a decision to SOMETIMES check 'make a backup'. I would like to check it when I want it checked, not when Excel decides to check it. SignatureJohn > Jim told you how you can turn off the creation of the backups. > [quoted text clipped - 35 lines] > > > > > > Dave Peterson I've never seen that option get turned on by excel. Maybe you created a workbook from an existing workbook that had option checked. Or maybe you used a template file that had this option checked. But I don't believe that excel changed it for you. > Yes, and I thanked him for it. My issue is with Microsoft Excel 2007 making a > decision to SOMETIMES check 'make a backup'. I would like to check it when I [quoted text clipped - 45 lines] > > > > Dave Peterson SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.