error when opening Tools/Options in excel 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
John said:
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
Click to expand...

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
 
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...
 
John said:
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...
Click to expand...

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
 
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,
 
Back
Top