it lost goal seek!

[anon125]

so i splurged and updated vista to win7 like the other computer.
both now have excel 2002.
http://www.4shared.com/photo/dUG8ApHS/goalseek_missing.html
this is a pic of the tools menu and goal seek just aint there!
i have the original discs and have repaired and reinstalled office.
still no goal seek!
any ideas?
thanks

 

[Nalani]

From the Help Files:

1. On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek.

Does that help?

 

[Peter_SSs]

For Excel 2002 Analysis ToolPak needs to be installed and activated.
Tools|Add-Ins...|check Analysis ToolPak|OK

 

[anon125]

thanks but....
there is no tools under data and the analysis is installed already.
so my goal is still to seek the goal seek!
thanks

 

[Nalani]

Sorry, I missed read your post.

My suggestion was for Excel 2007. But I see you have 2002.

So I will leave this up to Peter. I think he is more versed in 2002

 

[Peter_SSs]

.. the analysis is installed already.

Just confirming that it is not only installed, but also activated? That is, are you confirming that Analysis ToolPak has a check mark next to it in the Add-Ins window?

If so,

1. Try closing & re-opening Excel.

2. If still no joy you could try
Tools|Customize...|Toolbars tab|click on Worksheet Menu Bar to make it blue|Reset...
Note though, that if you have made other modifications to the menu bar, these modifications would be lost.

 

[anon125]

YEAH!!! thanks very much indeed

 

[Peter_SSs]

YEAH!!! thanks very much indeed

You are welcome.

Which bit fixed it?