View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default How can I use autosave from excel2000 in excel2003

Claude

This was an add-in in XL2000 and was incorporated and vastly improved in
2002/3. I could never successfully stop the old add-in from crashing excel
so worked without back-up support

The new version can have it's duration set via ToolOptions...Save to
different times , default - 10 mins. What Excel then does is save a temp
file at the duration to the location shown on the same tab. If you close
excel and no error/crash has occurred then excel wipes the temp file. If
you don't close Excel then you can go to this location, add an .xls
extension to the file you find and it will open.

The new version is *vastly* improved and knowing the above, is there any
reason to need the old add-in?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Claude J Johnson CPA Australia" <Claude J Johnson CPA
wrote in message
...
I have just upgraded from excel 2000 to excel 2003 I have always set
autosave
to 5 minutes in case I press the wrong button as I did tonight. I also had
autosave set to save all open workbooks
I am a heavy user of excel and often have many workbooks open at the one
time