Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ursula A.
 
Posts: n/a
Default Excel 2003 (XP), automatic save documents

With the previous excel versions document one could have the file saved
automatically every Minute if need be. Where is this function in Excel 2003??

If by error (and it happens too often) one closes a document without having
saved it manually first, the entire 2 - 3 hour job could be lost, and there
is no autorecovery file to be found either.

Can anyone indicate me, if possible with print screens how this precious
feature can be activated in Excel 2003?
--
Many thanks, and have a good day
Ursula A.
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

That feature's not available in XL03. However, Jan Karel Pieterse has an
add-in available, AutoSafe,

http://www.oaltd.co.uk/MVP/Default.htm

that provides that function.


In article ,
Ursula A. wrote:

With the previous excel versions document one could have the file saved
automatically every Minute if need be. Where is this function in Excel 2003??

If by error (and it happens too often) one closes a document without having
saved it manually first, the entire 2 - 3 hour job could be lost, and there
is no autorecovery file to be found either.

Can anyone indicate me, if possible with print screens how this precious
feature can be activated in Excel 2003?

  #3   Report Post  
Ursula A.
 
Posts: n/a
Default

Great, will try that out immediately. Thanks indeed!
--
Many thanks, and have a good day
Ursula A.


"JE McGimpsey" wrote:

That feature's not available in XL03. However, Jan Karel Pieterse has an
add-in available, AutoSafe,

http://www.oaltd.co.uk/MVP/Default.htm

that provides that function.


In article ,
Ursula A. wrote:

With the previous excel versions document one could have the file saved
automatically every Minute if need be. Where is this function in Excel 2003??

If by error (and it happens too often) one closes a document without having
saved it manually first, the entire 2 - 3 hour job could be lost, and there
is no autorecovery file to be found either.

Can anyone indicate me, if possible with print screens how this precious
feature can be activated in Excel 2003?


  #4   Report Post  
gls858
 
Posts: n/a
Default

JE McGimpsey wrote:
That feature's not available in XL03. However, Jan Karel Pieterse has an
add-in available, AutoSafe,

http://www.oaltd.co.uk/MVP/Default.htm

that provides that function.


In article ,
Ursula A. wrote:


With the previous excel versions document one could have the file saved
automatically every Minute if need be. Where is this function in Excel 2003??

If by error (and it happens too often) one closes a document without having
saved it manually first, the entire 2 - 3 hour job could be lost, and there
is no autorecovery file to be found either.

Can anyone indicate me, if possible with print screens how this precious
feature can be activated in Excel 2003?


What about tools Options save tab. It says AutoRecover,and has
a time interval. Is this something different from autosave or is it just a
change in semantics.

gls858
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Autosave used to save the file every X minutes. This prevented losing a
significant amount of work if you crashed, but it also saved your file,
thus preventing you from scrapping everything done in a session.

AutoRecover saves the *changes* you've made during a session every X
minutes (starting with the first change) in a temporary file. If XL
crashes, the temporary file remains on the disk, and when XL is next
started, it reconstructs the file from the temporary file. When you
close XL normally, any AR files are automatically deleted.

If you close XL without saving the file, the file will remain in the
state in which you opened it.



In article ,
gls858 wrote:

What about tools Options save tab. It says AutoRecover,and has
a time interval. Is this something different from autosave or is it just a
change in semantics.



  #6   Report Post  
gls858
 
Posts: n/a
Default

JE McGimpsey wrote:
Autosave used to save the file every X minutes. This prevented losing a
significant amount of work if you crashed, but it also saved your file,
thus preventing you from scrapping everything done in a session.

AutoRecover saves the *changes* you've made during a session every X
minutes (starting with the first change) in a temporary file. If XL
crashes, the temporary file remains on the disk, and when XL is next
started, it reconstructs the file from the temporary file. When you
close XL normally, any AR files are automatically deleted.

If you close XL without saving the file, the file will remain in the
state in which you opened it.



In article ,
gls858 wrote:


What about tools Options save tab. It says AutoRecover,and has
a time interval. Is this something different from autosave or is it just a
change in semantics.

Thanks JE I knew there had to be some difference or you would
have suggested the first time. To me it sounded like the same thing.

gls858
  #7   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you have your old (xl2k??) version of autosave.xla, it'll still work with
xl2002+.



Ursula A. wrote:

With the previous excel versions document one could have the file saved
automatically every Minute if need be. Where is this function in Excel 2003??

If by error (and it happens too often) one closes a document without having
saved it manually first, the entire 2 - 3 hour job could be lost, and there
is no autorecovery file to be found either.

Can anyone indicate me, if possible with print screens how this precious
feature can be activated in Excel 2003?
--
Many thanks, and have a good day
Ursula A.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 does not prompt to save changes when closing? Johnewally Excel Discussion (Misc queries) 1 March 17th 05 06:41 PM
Excel 2003 V's Excel 2000? Ket Excel Worksheet Functions 2 March 9th 05 12:05 PM
Save prompt for Excel 2003 Adrastos Setting up and Configuration of Excel 1 February 6th 05 07:54 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM


All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"