No Data Analysis item in Excel Tools menu. Now what?

H

hoakland

What if the ToolPak is installed but will not appear in tool menu on a
worksheet with graph displayed.
 
D

David Biddulph

It needs to be not only installed but enabled (under Tools/ Addins).
If that looks OK you could try disabling the Add-in, coming out of Excel (&
possibly rebooting your machine), then re-opening Excel and re-enabling the
Add-in. Excel does sometimes "forget" that the add-in was enabled.

Or going back to the last bit of your message, "Data Analysis" won't appear
on the Tools menu if you are looking at a chart, rather than a worksheet.
The menus for a chart are very different from the menus for a worksheet.
Data Analysis is a worksheet function, not a chart function. Go to a
worksheet, rather than a chart, and look again at your Tools menu.
 
G

Gord Dibben

If the Chart is selected you will get a different menu.

Do not select the Chart on the worksheet and you will see Tools>Data
Analysis.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top