 |
 | 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 / Setup / September 2007How do I set an autosave in Excel 2007
I am trying the Beta version of Office 2007 and wanted to know if there was an autosave feature in Excel - Office 2003 did not have this and that was very annoying! Alicia Excel has had autosave since XL2000. In that release it was an add-in, it was brought into the product as a standard feature in Excel 2002 (XP) so of course it's been in Excel 2003 and XL2007 too. It's on by default. You can look at the settings from the 'Office Button'>Excel Options...Save  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS >I am trying the Beta version of Office 2007 and wanted to know if there was > an autosave feature in Excel - Office 2003 did not have this and that was > very annoying! Nick There is no Autosave in XL2002 and 2003 as there was in earlier versions. Autorecovery from Tools>Options>Save is it. This is not the same as the Autosave Add-in which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. Alicia..........As far as Excel 2007...........I have no idea if the AUTOSAVE.XLA from Excel 2000 will function as it did in 2002 and 2003, if you can get your hands on a copy Gord Dibben MS Excel MVP >Alicia > [quoted text clipped - 3 lines] > >You can look at the settings from the 'Office Button'>Excel Options...Save Gord Yes, subtle difference I didn't pick up, although my experience with the xla was always bad, so I never used it, (crashed the app continuously when trying to save during other operations). The auto-recovery, which is really what Word, etc does is far more intuitive, granted it doesn't save a copy come what may, but maybe as I save regularly, or often start with a save as... I don't often have problems. Interestingly, since we have had Win 2003 server at work, you can simply restore previous versions by right clicking the file and choosing from any twice a day autosaved versions from the last five days. I suspect the old xla will work just as it did under 2002/3??? SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Nick > [quoted text clipped - 23 lines] >> >>You can look at the settings from the 'Office Button'>Excel Options...Save Gord, thank you - I found a similar thread you replied to with a link for '97 Autosave.xla and downloaded it. http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm My only problem now is how to access it through Excel 2007 as it's totally different to any previous versions of Excel. If you have any ideas I would appreciate it. There is an add-in tab but even after downloading autosave, it just has the pdf capability under that section. Is there a specific place I should be downloading the file to for Excel to automatically read it? thanks again Alicia > Nick > [quoted text clipped - 20 lines] > > > >You can look at the settings from the 'Office Button'>Excel Options...Save I have no idea how Office 2007 is structured. Wait for someone else to jump in. Thanks, Gord >Gord, thank you - I found a similar thread you replied to with a link for '97 >Autosave.xla and downloaded it. [quoted text clipped - 35 lines] >> > >> >You can look at the settings from the 'Office Button'>Excel Options...Save Gord Dibben MS Excel MVP Alicia To load an add-in in XL2007 go to Office Button>Excel Options...>Add-Ins>Manage Excel Add-Ins dropdown and select go... This launches the 'old' dialog and you can navigate to the xla from here. Once loaded it should show on the add-in tab SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS >I have no idea how Office 2007 is structured. > [quoted text clipped - 59 lines] > > Gord Dibben MS Excel MVP Thank you very much Nick, have located the autosafe.xla and it's now included in the list. I do just have one more question, sorry. Is there anyway to specifiy with this file where it saves too and how often it will auto backup? Thanks again for your help so far. Alicia. > Alicia > [quoted text clipped - 66 lines] > > > > Gord Dibben MS Excel MVP Alicia I'm not sure I remember how it was 'set' in XL2000. I only have XL2007 currently on this machine, so can't help Can anyone prompt me/Alicia how this was set in XL2000 and it may give me some clues SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Thank you very much Nick, have located the autosafe.xla and it's now > included [quoted text clipped - 82 lines] >> > >> > Gord Dibben MS Excel MVP Autosafe by JK when first loaded through Tools>Add-ins pops up a dialog allowing a path to be set, interval, language and others. Gord Dibben MS Excel MVP >Alicia > [quoted text clipped - 4 lines] >Can anyone prompt me/Alicia how this was set in XL2000 and it may give me >some clues Well, thank you guys for all your help, turns out that running autosafe crashes excel 2007 so i had to get rid of it as an add-in - hey-ho! It was a nice thought! take care > Autosafe by JK when first loaded through Tools>Add-ins pops up a dialog allowing > a path to be set, interval, language and others. [quoted text clipped - 9 lines] > >Can anyone prompt me/Alicia how this was set in XL2000 and it may give me > >some clues First you would re-post with some details of what you mean by "master default". Post your description in the body of the message please. Gord Dibben MS Excel MVP |
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.