Data Analysis Options disappears from <Tools> Pull Down Menu

C

ch

Hi everyone,

Sometimes the "Data Analysis" option disappears from my <tools> pull down
menu.
I can see it at other times, so it must have been installed.

What did I unknowingly that caused it to be hidden and how to get it back?

It is not hidden by Excel to keep the list short. There must be other
reasons for its disappearence.

ANyone, HELP !
 
M

Mangesh Yadav

Go to Tools > Addins
Check the box for Analysis ToolPak to view the Data Analysis option.

Mangesh
 
C

ch

I looked and see that the Data Analysis option is checked. The Data
Analysis Option is still not available.
 
Top