error when opening Tools/Options in excel 97

[Guest]

Hi all, I am using Excel 97, on Windows XP HomeEd SP2 for a few months now.
The other day, when I went to Tools/Options whilst I was in a document, it
came up with an error box, saying send report to Microsoft etc...and then
closing app, I am quite dumfounded, i have uninstalled etc. Other office
apps run perfect, as has excel until recently. Many thanks for your help

 

[Rob Bovey]

Hi all, I am using Excel 97, on Windows XP HomeEd SP2 for a few months
now.
The other day, when I went to Tools/Options whilst I was in a document, it
came up with an error box, saying send report to Microsoft etc...and then
closing app, I am quite dumfounded, i have uninstalled etc. Other office
apps run perfect, as has excel until recently. Many thanks for your help

Hi John,

The following Knowledge Base article describes this problem and how to
fix it:

http://support.microsoft.com?kbid=168201

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Guest]

Thanks Rob, but still have problem, since I reinstalled my default is My
Documents. Now I did notice that my user a/c under Docs&Sett's has many no's
after my name, (John A K 9D123C54 ..etc) I think this is whats blowing it.
How can I change it it wont let me...go through reg ?.. Many thanks again...

 

[Rob Bovey]

Thanks Rob, but still have problem, since I reinstalled my default is My
Documents. Now I did notice that my user a/c under Docs&Sett's has many
no's
after my name, (John A K 9D123C54 ..etc) I think this is whats blowing it.
How can I change it it wont let me...go through reg ?.. Many thanks
again...

Hi John,

If you're comfortable using RegEdit to modify Excel's registry entries
directly, the easiest thing to do would be to close Excel and navigate to
the following key:

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel

Find the value named DefaultPath on the right side, double-click it and
enter some really short valid path like C:\. The problem should then be
gone.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Guest]

Brilliant thanks Rob, I went in yesterday and snooped around, but werent sure
impact on DefaultPath, so thanks once again, dont know why it came about when
I've been using it for mths, I guess one of those things.
Regards,