ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Analysis Options disappears from Pull Down Menu (https://www.excelbanter.com/excel-discussion-misc-queries/28881-data-analysis-options-disappears-%3Ctools%3E-pull-down-menu.html)

ch

Data Analysis Options disappears from Pull Down Menu
 
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 !

Mangesh Yadav

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

Mangesh



"ch" wrote in message
...
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 !




ch


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


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com