software

The instructions in Auto recover don't appear to create a new (backup)
workbook. Am I doing something wrong? Advice please.

Autorecover doesn't create a backup. It essentially creates a copy every x
minutes (user selectable). So if excel or windows crashes, excel will be able
to find that copy and save everything since that copy was made.

This is different than the way autosave worked in previous versions. That
didn't create a backup either, though. It would just write over the file every
so often.
Sheskaty wrote:
gt;
gt; The instructions in Auto recover don't appear to create a new (backup)
gt; workbook. Am I doing something wrong? Advice please.

--

Dave Peterson

That's what I thought! The tech guy at my husband's office insisted that it
was possible to make Excel create a quot;backup of xxxquot; file as you can in Word,
but couldn't say how (funnily enough!). I explained to my husband over the
phone how to set Excel up to Auto recover, but his techie was insistant that
it was possible to create another file too. Thanks for the quick response - I
can now go say quot;I told you so!quot;

quot;Dave Petersonquot; wrote:

gt; Autorecover doesn't create a backup. It essentially creates a copy every x
gt; minutes (user selectable). So if excel or windows crashes, excel will be able
gt; to find that copy and save everything since that copy was made.
gt;
gt; This is different than the way autosave worked in previous versions. That
gt; didn't create a backup either, though. It would just write over the file every
gt; so often.
gt;
gt;
gt;
gt; Sheskaty wrote:
gt; gt;
gt; gt; The instructions in Auto recover don't appear to create a new (backup)
gt; gt; workbook. Am I doing something wrong? Advice please.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Ahh. A different question.

If you go into File|SaveAs|Tools|General options (xl2002 ) wording, you can
check the quot;Always create backupquot; box.

But this is a workbook by workbook setting (different from MSWord).

You can create a workbook template that has this setting and use it as the basis
for any new workbook when you click on the New icon on the standard toolbar.

Start a new workbook
file|SaveAs|tools|general options (and check that box)
template (*.xlt)
and save it in your XLStart folder.

I hope you weren't too, er, what's that word... I'm sure you'll hear it from the
techie guy lt;vbggt;.

Sheskaty wrote:
gt;
gt; That's what I thought! The tech guy at my husband's office insisted that it
gt; was possible to make Excel create a quot;backup of xxxquot; file as you can in Word,
gt; but couldn't say how (funnily enough!). I explained to my husband over the
gt; phone how to set Excel up to Auto recover, but his techie was insistant that
gt; it was possible to create another file too. Thanks for the quick response - I
gt; can now go say quot;I told you so!quot;
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Autorecover doesn't create a backup. It essentially creates a copy every x
gt; gt; minutes (user selectable). So if excel or windows crashes, excel will be able
gt; gt; to find that copy and save everything since that copy was made.
gt; gt;
gt; gt; This is different than the way autosave worked in previous versions. That
gt; gt; didn't create a backup either, though. It would just write over the file every
gt; gt; so often.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Sheskaty wrote:
gt; gt; gt;
gt; gt; gt; The instructions in Auto recover don't appear to create a new (backup)
gt; gt; gt; workbook. Am I doing something wrong? Advice please.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Well ... fortunately I'm in the UK amp; it's 11:33 pm here, so I haven't had the
opportunity to say anything at all to him yet! Not that I would be rude to
the man .... probably not anyway!

He just thinks he know it all - he once told my husband that the reason he
couldn't send files to his company's server was because - wait for it - he
had the wrong kind of keyboard! Please don't ask me what he meant by that - I
spent 20 years working for an IT company, the last 10 in hardware amp; software
diagnostics amp; support for networked systems amp; I've no idea what he was
talking about! I think it's the best BS explaination I've ever heard - amp; I'm
the one who had to call a client up to explain what a colleague meant when he
left a message saying quot;RTFMquot;!

I am having a little trouble with the last part of your fix though. At home
I have Excel 2003 amp; I can set up each file fine, but whe I try to set up a
workbook template I get to quot;general optionsquot; but don't get the quot;templatequot; bit
- perhaps it's a European version or it's just passed my bed-time!

Thanks again for your helpThe template option is on the main File|SaveAs dialog--at the bottom of the
dialog--quot;Save as typequot; box.

(Sorry about the confusion--I think it was my keyboard is USA Centric lt;vbggt;.)
Sheskaty wrote:
gt;
gt; Well ... fortunately I'm in the UK amp; it's 11:33 pm here, so I haven't had the
gt; opportunity to say anything at all to him yet! Not that I would be rude to
gt; the man .... probably not anyway!
gt;
gt; He just thinks he know it all - he once told my husband that the reason he
gt; couldn't send files to his company's server was because - wait for it - he
gt; had the wrong kind of keyboard! Please don't ask me what he meant by that - I
gt; spent 20 years working for an IT company, the last 10 in hardware amp; software
gt; diagnostics amp; support for networked systems amp; I've no idea what he was
gt; talking about! I think it's the best BS explaination I've ever heard - amp; I'm
gt; the one who had to call a client up to explain what a colleague meant when he
gt; left a message saying quot;RTFMquot;!
gt;
gt; I am having a little trouble with the last part of your fix though. At home
gt; I have Excel 2003 amp; I can set up each file fine, but whe I try to set up a
gt; workbook template I get to quot;general optionsquot; but don't get the quot;templatequot; bit
gt; - perhaps it's a European version or it's just passed my bed-time!
gt;
gt; Thanks again for your help

--

Dave Peterson

Hi

I'm also in the Uk and using XL2003.
The template option Dave is talking about is found when you do
Filegt;Save Asgt;bottom dropdown Save as Typegt; 5th item down Template
(*.xlt)

--
Regards

Roger Govierquot;Sheskatyquot; gt; wrote in message
...
gt; Well ... fortunately I'm in the UK amp; it's 11:33 pm here, so I haven't
gt; had the
gt; opportunity to say anything at all to him yet! Not that I would be
gt; rude to
gt; the man .... probably not anyway!
gt;
gt; He just thinks he know it all - he once told my husband that the
gt; reason he
gt; couldn't send files to his company's server was because - wait for
gt; it - he
gt; had the wrong kind of keyboard! Please don't ask me what he meant by
gt; that - I
gt; spent 20 years working for an IT company, the last 10 in hardware amp;
gt; software
gt; diagnostics amp; support for networked systems amp; I've no idea what he was
gt; talking about! I think it's the best BS explaination I've ever heard -
gt; amp; I'm
gt; the one who had to call a client up to explain what a colleague meant
gt; when he
gt; left a message saying quot;RTFMquot;!
gt;
gt; I am having a little trouble with the last part of your fix though.
gt; At home
gt; I have Excel 2003 amp; I can set up each file fine, but whe I try to set
gt; up a
gt; workbook template I get to quot;general optionsquot; but don't get the
gt; quot;templatequot; bit
gt; - perhaps it's a European version or it's just passed my bed-time!
gt;
gt; Thanks again for your help
gt;
Thanks to both of you for your help - I think I know what I'm doing now. All
I have to do is talk my husband through it - considering that when asked what
kind of PC he had at work, his answer was quot;a gray onequot; I don't hold out much
hope, but who knows!
It might be worth getting him one of those portables that you reboot by shaking
it over your head:

www.etoys.com/genProduct.html...7/INstock/N/D/

Sheskaty wrote:
gt;
gt; Thanks to both of you for your help - I think I know what I'm doing now. All
gt; I have to do is talk my husband through it - considering that when asked what
gt; kind of PC he had at work, his answer was quot;a gray onequot; I don't hold out much
gt; hope, but who knows!

--

Dave Peterson

Dave, now look what you've done!!!
You've caused a rush on these and now they are sold outlt;vbggt;

--
Regards

Roger Govierquot;Dave Petersonquot; gt; wrote in message
...
gt; It might be worth getting him one of those portables that you reboot
gt; by shaking
gt; it over your head:
gt;
gt; www.etoys.com/genProduct.html...7/INstock/N/D/
gt;
gt; Sheskaty wrote:
gt;gt;
gt;gt; Thanks to both of you for your help - I think I know what I'm doing
gt;gt; now. All
gt;gt; I have to do is talk my husband through it - considering that when
gt;gt; asked what
gt;gt; kind of PC he had at work, his answer was quot;a gray onequot; I don't hold
gt;gt; out much
gt;gt; hope, but who knows!
gt;
gt; --
gt;
gt; Dave Peterson