SOLVED

Need Data Analysis for Excel 365, but no options exist

Copper Contributor

I'm using the student office 365 and I need the data analysis tool pak add in, but I have no way to add it. There's no "options" menu and when I go to add ins it says that individual acquisition of add in has been disabled.

2 Replies
best response confirmed by Abiola1 (MVP)
Solution

@GhostSmoke 

Hello, to activate the Data Analysis ToolPak:

File>Options>Add-ins>Excel Add-ins>click on Data Analysis ToolPak box>Click OK

Abiola1_0-1581972603918.png

Abiola1_1-1581972675004.png

After you click OK, you will have it right-most of your Data tab as seen in the caption below

Abiola1_2-1581972740256.png

 

 

 

I’m using a student version of Excel. Under the file menu, I click options, and the only option I have is to change the language preference.
1 best response

Accepted Solutions
best response confirmed by Abiola1 (MVP)
Solution

@GhostSmoke 

Hello, to activate the Data Analysis ToolPak:

File>Options>Add-ins>Excel Add-ins>click on Data Analysis ToolPak box>Click OK

Abiola1_0-1581972603918.png

Abiola1_1-1581972675004.png

After you click OK, you will have it right-most of your Data tab as seen in the caption below

Abiola1_2-1581972740256.png

 

 

 

View solution in original post