1

Topic: Autosave Excel

Good afternoon!
If I correctly understand, autosave is when automatically (through the period specified in adjustments) happens that happens at pushing to "Save". For some reason it does not happen: if to close a file without pushing to "Save", all editings even made long before the outflow of the period of autosave, are not saved. How to organize correctly autosave?
And still, from other area. If to pull for a dagger in a cell corner in which it is written, let us assume, "1" will be 2 more low, 3, 4 etc. and if it is simple "1" "1" will be  and more low. The job of various formats (the text, the general, number...) does not influence. Why?

2

Re: Autosave Excel

ARDL
If I correctly understand, autosave
You misunderstand... Probably, because neglect help reading:

Autosave everyone Automatically creates a file of recovery of the book with an interval entered in the field of minutes. The interval should be the positive number from 1 to 120. If the computer ceases to respond to actions of the user or a supply was unexpectedly disconnected, at next run Excel the autorecovery file opens. The autorecovery file can contain the information not saved in the book which otherwise would be lost. If the book has been damaged, it is possible to recover the information which was in it from an autorecovery file.
Important. Autosave does not replace a command to Save. at the termination of operation with the book it is necessary for saving.

and still, from other area.
If in a cell the number contains - copying is selected from autocompletion parameters, and if a line terminating in a numerical fragment - that filling. Here too it was possible to esteem the built in help...

3

Re: Autosave Excel

Thanks!
Akina
  too it was possible to esteem the built in help...
The answer of the guru is always better than the misunderstood text)))
Autosave does not replace a command to Save.
Whether and it is impossible to register any macro that this command was fulfilled automatically through the installed period?

4

Re: Autosave Excel

ARDL
And whether it is impossible to register any macro that this command was fulfilled automatically through the installed period?
It is possible...

5

Re: Autosave Excel

Akina
It is possible...
And how?

6

Re: Autosave Excel

Write the procedure fulfilling saving.
From other procedure (we tell, WorkBook_Load) fulfill single-valuedly something like

 Application. OnTime EarliestTime: = Now () + TimeValue ("0:02:00 AM"), _
Procedure: = "Unconditional_Save_Procedure"

Just the same line - last in the procedure.
Effect:  procedure performance in 2 minutes after code performance. Each start of procedure  its new start.
All problems with offset/loss of focus and the other procedures of saving connected to performance - at own expense.