I want my spreadsheets to automatically back up every few minutes. Is this
possible? If so how do I do it.
Thank you.
I want my spreadsheets to automatically back up every few minutes. Is this
possible? If so how do I do it.
Thank you.
Hi,
Tools>Options>Save - this will give you an option to save every xx minutes.
Hope this helps
Sunil Jayakumar
"laldybug" <[email protected]> wrote in message
news:[email protected]...
>I want my spreadsheets to automatically back up every few minutes. Is this
> possible? If so how do I do it.
> Thank you.
www.ayyoo.com/loans.html
Thanks a lot Sunil. One more quick question - what is the backup function in
file save>general options>back up box for? Where and when will the
spreadsheet be backed up in that case.
Sharon
"Sunil Jayakumar" wrote:
> Hi,
>
> Tools>Options>Save - this will give you an option to save every xx minutes.
>
> Hope this helps
>
> Sunil Jayakumar
>
> "laldybug" <[email protected]> wrote in message
> news:[email protected]...
> >I want my spreadsheets to automatically back up every few minutes. Is this
> > possible? If so how do I do it.
> > Thank you.
>
> www.ayyoo.com/loans.html
>
>
>
Hi,
If you use this option, it will always create and save one more copy of your
sheet, so should you corrupt the file you are working on, or need to go back
to an earlier version of your work, you can recover it from there.
The Autorecover/Autosave will help you recover work in case of a crash - the
backup option is really there to protect you from yourself
Hope this helps
Sunil Jayakumar
"laldybug" <[email protected]> wrote in message
news:[email protected]...
> Thanks a lot Sunil. One more quick question - what is the backup function
> in
> file save>general options>back up box for? Where and when will the
> spreadsheet be backed up in that case.
> Sharon
>
> "Sunil Jayakumar" wrote:
>
>> Hi,
>>
>> Tools>Options>Save - this will give you an option to save every xx
>> minutes.
>>
>> Hope this helps
>>
>> Sunil Jayakumar
>>
>> "laldybug" <[email protected]> wrote in message
>> news:[email protected]...
>> >I want my spreadsheets to automatically back up every few minutes. Is
>> >this
>> > possible? If so how do I do it.
>> > Thank you.
>>
>> www.ayyoo.com/loans.html
>>
>>
>>
www.ayyoo.com/credit-cards.html
hi again,
I have entered a new spot for my spreadsheet to back up and it doesn't
appear to be working, I put a backup of every minute. Example: the
destination for backup that I put in is C:
Do you know why I can not find it on C: ?
Thank you,
Sharon
"Sunil Jayakumar" wrote:
> Hi,
>
> If you use this option, it will always create and save one more copy of your
> sheet, so should you corrupt the file you are working on, or need to go back
> to an earlier version of your work, you can recover it from there.
>
> The Autorecover/Autosave will help you recover work in case of a crash - the
> backup option is really there to protect you from yourself
>
> Hope this helps
>
> Sunil Jayakumar
>
>
> "laldybug" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks a lot Sunil. One more quick question - what is the backup function
> > in
> > file save>general options>back up box for? Where and when will the
> > spreadsheet be backed up in that case.
> > Sharon
> >
> > "Sunil Jayakumar" wrote:
> >
> >> Hi,
> >>
> >> Tools>Options>Save - this will give you an option to save every xx
> >> minutes.
> >>
> >> Hope this helps
> >>
> >> Sunil Jayakumar
> >>
> >> "laldybug" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >I want my spreadsheets to automatically back up every few minutes. Is
> >> >this
> >> > possible? If so how do I do it.
> >> > Thank you.
> >>
> >> www.ayyoo.com/loans.html
> >>
> >>
> >>
>
> www.ayyoo.com/credit-cards.html
>
>
>
What version of excel do you have?
In xl2k and earlier, there's an autosave addin you can turn on (tools|Addins).
If you don't see it there, have your distribution CD available.
In fact, that addin will work with xl2002 and xl2003, too!
If you're using xl2002+, you can turn on autorecover--but this is different from
AutoSave.
The workbook is saved as a different name/folder every xx minutes (user
selectable).
If excel/windows crashes, the next time you start excel, it'll notice this file
and prompt you to find out if you want to use it.
If excel closes normally, this file is deleted (never to be heard from again!).
Another option:
You can use an addin from Jan Karel Pieterse called AutoSafe.
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.
http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.
laldybug wrote:
>
> I want my spreadsheets to automatically back up every few minutes. Is this
> possible? If so how do I do it.
> Thank you.
--
Dave Peterson
"laldybug" <[email protected]> wrote in message
news:[email protected]...
> hi again,
> I have entered a new spot for my spreadsheet to back up and it doesn't
> appear to be working, I put a backup of every minute. Example: the
> destination for backup that I put in is C:
> Do you know why I can not find it on C: ?
> Thank you,
> Sharon
>
Excel will probably create hidden files.
/Fredrik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks