Hi vercingatorix,
Thanks for asking, I learned something new today. There is an easy fix
for you. Evidentally when Microsoft released this version of Excel,
there was a patch/fix released at a later date that specifically
addresses this problem. Here it is:
XL2000: AutoSave Settings Are Not Retained Between Sessions of Excel
2000
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q231/1/17.asp&NoWebContent=1
..."This problem was corrected in Microsoft Office 2000 SR-1/SR-1a..."
This is an excellent example of why folks need to keep current on
patches and updates at the [free] Microsoft Updates web site:
Welcome to Windows Update
http://v4.windowsupdate.microsoft.com/en/default.asp
..."Get the latest updates available for your computer's operating
system, software, and hardware....Windows Update scans your computer
and provides you with a selection of updates tailored just for you..."
This is safe, quick, and thorough.
What I would recommend is going to the Microsoft Update site first,
before installing the patch for Excel 2000. It's a certainty that
Microsoft will tell you need it, and other updates too. After
scanning, you can just put a check mark next to the items you want
and/or need, and select to have them downloaded and installed.
If I can be of any further assistance, please don't hesitate to ask
for a clarification of my answer, before rating me, ok?
Best regards,
~~Cynthia |
Request for Answer Clarification by
vercingatorix-ga
on
07 Jul 2003 12:26 PDT
A appreciate your prompt response, but that's not the answer I need.
You're right about the documentation for the patch. But I installed
that patch a month ago, hoping it would fix the problem. It has not.
I suspect the issue is some sort of internal Excel control or setting
rather than a Windows functionality issue.
I'm afraid I can't accept the answer as it is currently presented,
because the patch by itself was unable to get the job done.
V
|
Clarification of Answer by
cynthia-ga
on
07 Jul 2003 13:32 PDT
Hi again vercingatorix,
No problem. I'll work with you to try to find the solution, and if I'm
unable, I'll ask to have my answer removed so another Researcher can
tackle it.
To look for it I changed my search terms to:
"AutoSave Setting" "Excel 2000"
...and received one good result:
Cached Google Page
http://216.239.53.104/search?q=cache:DGmS4WsVoTUJ:www.pcsupportadvisor.com/sasample/R1175.PDF+%22AutoSave+Setting%22+%22Excel+2000%22&hl=en&ie=UTF-8
Scroll to the first result in YELLOW:
..."Excel and PowerPoint now have AutoSave options similar to those in
Word, and ifusers choose the default of using Word to compose Outlook
email they’ll have thedata recovery features of Word for messages too.
You’ll find the AutoSave settingin the same Save pane on the
Tools/Option dialog in all three programs, but theoptions differ
somewhat for each package..."
Does this help?
~~Cynthia
|
Clarification of Answer by
cynthia-ga
on
07 Jul 2003 16:06 PDT
I'm available between 8am and 4pm PDT all week, so if I don't respond
to a request to a request for clarification in the evening, you'll
know why, and when to check...
~~Cynthia
|
Request for Answer Clarification by
vercingatorix-ga
on
08 Jul 2003 11:52 PDT
That cached page really doesn't help because it applies to Office XP,
rather than the Office 2000 I'm using. And it never explains how to
make the changes permanent, suggesting that in XP the functionality is
right there, easy to find in the form of a button or pull-down menu.
V
|
Clarification of Answer by
cynthia-ga
on
08 Jul 2003 14:22 PDT
***********FIRST
Have you, for sure, installed the AutoSave add-in from your Office
CD??
SAVING FILES AUTOMATICALLY
http://216.239.57.104/search?q=cache:hXdm91wMplYJ:users.telenet.be/solvenet/excel2.htm+%22excel+2000%22+autosave+permanent&hl=en&ie=UTF-8
..."Excel has an add-in you may find indispensable if you like to save
files at regular intervals. We're referring to the AutoSave add-in.
Once you've installed this add-in, you can specify how often Excel
will save the current workbook (or all open workbooks).
To install the AutoSave add-in, choose Tools, Add-ins. Then, select
AutoSave Add-in and click OK. After installing, you'll have to enable
the add-in by selecting Tools, AutoSave and then specifying the
following options:
- Automatic Save Entry: Determines how often Excel saves.
- Save Options: You can save just the active workbook or all the open
workbooks.
- Prompt Before Saving: If selected, Excel will prompt you before
each save task.
One annoying feature of this add-in is that you can't turn it off--the
timed interval cannot equal 0.
Note: Chances are this add-in isn't installed, so you may need your
Office CD ..."
***********NEXT:
Have you configured the AutoSave add-in?
Excel 2000 Tips & Tricks
http://www.microsoft.com/office/previous/tips/excel2000.asp
Scroll to:
..."Have Excel Save Your Files Automatically
From Chetan Parmar, Hasbrouck Heights, New Jersey
Have you ever wanted Excel to automatically save your spreadsheets for
you so you don't lose your work? Excel 2000 includes a feature that
saves workbooks automatically at specified intervals, but it's not
installed by default. Here's how you can install and use the Autosave
Add-in:
First you need to load the add-in, which will add it to your Tools
menu:
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Autosave Add-in check box
and then click OK.
(Editor's Note: If the Autosave Add-in is not available, you may need
to install it. For more instructions, search for the phrase "Install
or remove individual features of Microsoft Office or Excel" in Excel
2000 Help.)
Then, to configure and use the Autosave feature:
1) On the Tools menu, click AutoSave.
2) Select the Automatic save every check box.
3) In the Minutes box, enter how often you want Excel to save your
workbooks.
4) Select any other options you want, and press OK ..."
There's an overview of the AutoSave functionality here:
EXCEL 2000
http://muskie.usm.maine.edu/ttg/Courseware/Excel2000.pdf
Scroll to Page 11 under "Saving a Workbook"
It might be easier to find here, it's the cached html page of the same
PDF document:
http://216.239.39.104/search?q=cache:vVkzHvuZ_bAJ:muskie.usm.maine.edu/ttg/Courseware/Excel2000.pdf+%22excel+2000%22+autosave+troubleshooting&hl=en&ie=UTF-8
I'll be here for another 1.5 hours, and check back in the morning at
8am sharp. Let me know how we're doing.
~~Cynthia
|
Request for Answer Clarification by
vercingatorix-ga
on
08 Jul 2003 17:31 PDT
In answer to your question, yes, I'm sure the add-in is installed. If
it were not, I could not use the feature at all. And I am currently
using AutoSave. I can adjust the frequency, the number of workbooks
saved, and the notification feature. The problem is that I must adjust
them every time I open Excel.
My issue is not an inability to use AutoSave. It's simply an inability
to make Excel remember my settings. I know the functionality exists
because Excel remembered my settings before our IT staff gave me a new
machine.
I read the manual you provided, and it said nothing about saving
settings.
V
|
Clarification of Answer by
cynthia-ga
on
09 Jul 2003 10:07 PDT
Hi again vercingatorix,
Your answers lead me back to the beginning. The autosave settings bug
is supposed to be repaired by the installation of the Service Pack I
mentioned in my first answer.
My next step was to go BACK to the Microsoft site in search of the
answer.
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q231/1/17.asp&NoWebContent=1
Which directs one here:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000
Service Release 1/1a (SR-1/SR-1a)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;245025#Topic2
..."Microsoft has confirmed that this is a problem in the Microsoft
products that are listed at the beginning of this article. This
problem was corrected in Microsoft Office 2000 SR-1/SR-1a..."
Once there I found a couple things that might be causing the problem:
1) Confirm that the service pack is actually installed. Directions on
how to do this are at the link above.
2) Office 2000 Service Release 1a (SR-1a) Update - Important
Information for Windows 2000 Users
http://office.microsoft.com/assistance/2000/o2ksr1up.aspx
..."If you applied the Office 2000 SR-1 update and upgraded your PC
from Microsoft Windows NT® 4 to Windows® 2000 before May 12, 2000, you
should apply the Microsoft Office 2000/Windows 2000 Registry Repair
Utility. This utility restores the registry settings for several
important files that prevent potential issues. For more information on
specific issues, please see the KnowledgeBase article #Q258549.
Users that didn't install the SR-1 update before May 12, 2000 should
install the Office 2000 SR-1a update, which includes the Office
2000/Windows 2000 Registry Repair Utility..."
Have you noticed any other odd behavior?
OFF2000: Odd Behavior on Windows 2000 After You Install Office 2000
SR-1 Update
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q258/5/49.asp&NoWebContent=1
3) What the Office 2000 SR-1/SR-1a Update Does Not Do
http://support.microsoft.com/default.aspx?scid=kb;EN-US;245025#Topic2
..."The SR-1/SR-1a Update does not update any of the following:
Administrative installations of Microsoft Office 2000. If you need to
update an administrative installation, you must obtain a special
version of the SR-1/SR-1a Update that is designed specifically for
administrative installations. After your system administrator has
installed the special SR-1/SR-1a Update for administrative
installations, the administrator can instruct you in how to update
your installation of Office 2000 to SR-1/SR-1a level...
The answer has to be one of these three things, because the bug is
repaired in the service pack of the non-administrative version. So,
I'm REALLY hoping that you are using a computer that's on a network,
at work. If this is the case, you'll need to ask (or install yourself
if you are the admin) for the Administrative Version of the Service
Pack to be installed.
It's here:
OFF2000: How to Obtain and Apply the SR-1/SR-1a Update to
Administrative Installations
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q258/5/49.asp&NoWebContent=1
..."The Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
Administrator Update is designed to update an administrative
installation of your Office 2000 programs and supporting files to
SR-1/SR-1a level. This article explains how to download and install
the Microsoft Office 2000 SR-1/SR-1a Administrator Update..."
*fingers crossed*
Let me know...
~~Cynthia
|
