|
Related Topics:
| Auto sum? - If I want the mileage for a month it would subtract the smaller from the larger number, opposite of sum. Is there a way to do this I am putting a formula in a cell manually. But there will be more entries for the month. Can this be updated..
Auto hyperlink - I have told Word not to insert for e-mail addresses and URLs. But I can't see how to tell Excel the same. I thought the programs talked to each other ...?
auto filter - It appears that doesn't work if there are blank rows. The sort goes only up to the first blank row, true? Any work around? OS 10.3.2 -- Harvey Products makers of Dinghy Dogs The Boater's Best Friend Remove..
Auto fill - Sorry - I entered numbers in the cells in the last posting, I meant to enter cell If I enter in B1, in B2, I can drag to auto fill the rest of column B and it will fill in =A3, =A4, etc. I need to know how to do this if I enter..
Auto Filter - Hi, I have just turned on Auto Filter so that I can sort the names in a column in order. I was able to do this, but wondered is there a way to get them back to what they were prior to I know you can uncheck the auto filter which..
|
|
|
Next: Excel: Where is history
|
| Author |
Message |
External
Since: Apr 16, 2007
Posts: 140
|
(Msg. 1) Posted: Mon Dec 31, 2007 11:10 am
Post subject: Auto recover - auto back up
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
|
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 2) Posted: Mon Dec 31, 2007 12:54 pm
Post subject: Re: Auto recover - auto back up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <C39E7EB3.2FB3C%kevs@hotmail.com>, kevs <kevs.RemoveThis@hotmail.com>
wrote:
> Just lost lot of work today. Can someone please let me know how to use these
> feature best for future? Appreciate it.
There is no Auto backup function in XL. You can set each file to create
a backup *when saved* (click the Options Button in the Save As dialog).
If you want all new files to create a backup, check that checkbox when
you save your default workbook (i.e., the file "Workbook", no quotes, no
extensions, in your XL startup folder).
Autorecover settings depend on how frequently you want to save (more
frequent if you're entering a lot of data, less frequent if not - I use
5 minutes). Autorecover can cause XL to pause momentarily while the
autorecover file is saved, so more frequent is not necessarily better.
Autorecover only protects against crashes - when XL starts up, it looks
for an Autorecover file. If one exists, XL presumes there was a crash,
and opens the Autorecover file. Autorecover files are deleted when you
close XL normally.
The best usage is, as in Word, to get used to typing CMD-s frequently. |
|
| Back to top |
|
| |
External
Since: Jul 20, 2005
Posts: 1719
|
(Msg. 3) Posted: Mon Dec 31, 2007 6:21 pm
Post subject: Re: Auto recover - auto back up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yes - ignore them, leaving them at their default settings & pray that you
never have a situation occur that causes them to exhibit what they are
designed to do. In the meanwhile learn to use Command+S periodically while
you work.
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 12/31/07 2:10 PM, in article C39E7EB3.2FB3C%kevs@hotmail.com, "kevs"
<kevs.DeleteThis@hotmail.com> wrote:
> Just lost lot of work today. Can someone please let me know how to use these
> feature best for future? Appreciate it.
>
> Kevs
>
>
> OS 10.4.11
> Office 2004
>
> >> Stay informed about: Auto recover - auto back up |
|
| Back to top |
|
| |
External
Since: Apr 16, 2007
Posts: 140
|
(Msg. 4) Posted: Tue Jan 01, 2008 12:12 pm
Post subject: Re: Auto recover - auto back up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 12/31/07 3:21 PM, in article C39EE39D.2F8F7%onlygeneraltaz1@com.cast.net,
"CyberTaz" <onlygeneraltaz1 RemoveThis @com.cast.net> wrote:
> Yes - ignore them, leaving them at their default settings & pray that you
> never have a situation occur that causes them to exhibit what they are
> designed to do. In the meanwhile learn to use Command+S periodically while
> you work.
>
> Regards |:>)
> Bob Jones
> [MVP] Office:Mac
>
>
>
> On 12/31/07 2:10 PM, in article C39E7EB3.2FB3C%kevs@hotmail.com, "kevs"
> <kevs RemoveThis @hotmail.com> wrote:
>
>> Just lost lot of work today. Can someone please let me know how to use these
>> feature best for future? Appreciate it.
>>
>> Kevs
>>
>>
>> OS 10.4.11
>> Office 2004
>>
>>
>
Thanks guys, just exploring everything after this recent disaster.
Kevs
OS 10.4.11
Office 2004 >> Stay informed about: Auto recover - auto back up |
|
| Back to top |
|
| |
External
Since: Mar 31, 2008
Posts: 1
|
(Msg. 5) Posted: Mon Mar 31, 2008 4:33 pm
Post subject: Re: Auto recover - auto back up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
So, if XL makes an auto recover file, where does it put this file? Assuming a mistake (closing without saving the wrong workbook when you have several open at once) and a "normal" (non crash) close, does the auto recover file stay somewhere or is it trashed if the associated workbook is closed?
thanks >> Stay informed about: Auto recover - auto back up |
|
| Back to top |
|
| |
External
Since: May 06, 2008
Posts: 1
|
(Msg. 6) Posted: Tue May 06, 2008 6:48 pm
Post subject: Re: Auto recover - auto back up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 7) Posted: Wed May 07, 2008 5:27 am
Post subject: Re: Auto recover - auto back up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee870e8.4.DeleteThis@webcrossing.caR9absDaxw>,
hannahmadeleine.DeleteThis@officeformac.com wrote:
> is there any way to recover a file that i didn't save (and no, i don't use
> time machine...)? i think i already know the answer, but just checking.
If you quit XL normally, then you're out of luck. AutoRecover will only
recover files that were in use if XL crashes. >> Stay informed about: Auto recover - auto back up |
|
| Back to top |
|
| |
|
FAQ
Search
Profile
Private Messages
Log in/Register/Password
