ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Where is data analysis tool? (https://www.excelbanter.com/excel-worksheet-functions/34058-where-data-analysis-tool.html)

tamorn

Where is data analysis tool?
 
My data analysis toolback is apparently installed, but the "Data analysis"
function is not appearing under the Tools Menu. How can I fix this?

Anne Troy

You may need to reset your Worksheet Menu Bar. Go to Tools--Customize, and
go to the Toolbars tab. Choose the Worksheet menu bar, and hit RESET.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"tamorn" wrote in message
...
My data analysis toolback is apparently installed, but the "Data analysis"
function is not appearing under the Tools Menu. How can I fix this?




Daniel CHEN

Goto menu: Tools-add-in and make "analysis toolpak" checked.

Yongjun CHEN

"tamorn" wrote in message
...
My data analysis toolback is apparently installed, but the "Data analysis"
function is not appearing under the Tools Menu. How can I fix this?




KP

Hey, I just tried that as I am having the same problem. But it did not work
for me. Data Analysis still does not appear in my tools menu.

"Anne Troy" wrote:

You may need to reset your Worksheet Menu Bar. Go to Tools--Customize, and
go to the Toolbars tab. Choose the Worksheet menu bar, and hit RESET.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"tamorn" wrote in message
...
My data analysis toolback is apparently installed, but the "Data analysis"
function is not appearing under the Tools Menu. How can I fix this?





Dave H

"KP" wrote in message
...
Hey, I just tried that as I am having the same problem. But it did not
work
for me. Data Analysis still does not appear in my tools menu.

"Anne Troy" wrote:

You may need to reset your Worksheet Menu Bar. Go to Tools--Customize,
and
go to the Toolbars tab. Choose the Worksheet menu bar, and hit RESET.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"tamorn" wrote in message
...
My data analysis toolback is apparently installed, but the "Data
analysis"
function is not appearing under the Tools Menu. How can I fix this?



Go to Tools Add-Ins and make sure "Analysis Toolpak" is checked on - if
not check it on - should then appear on the bottom of the Tools menu (make
sure you click in the chevron at the bottom of the menu if this is visible,
as it may be a hidden menu item).

Cheers Dave H.




All times are GMT +1. The time now is 07:06 PM.

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