Data Analysis

Copper Contributor

I am unable to get "Data Analysis tab" under data tab after trying add-ins and everything else as well. I tried using my university mail and personal gmail ids to log into the systems as well. Can you guys help me with it??

7 Replies

@adarshsingh 

Assuming that you use Excel for Windows:

Select File > Options.

Select Add-ins.

Select 'Excel Add-ins' from the Manage drop-down near the bottom, then click Go...

HansVogelaar_1-1693047679832.png

Do you see Analysis ToolPak in the list of available add-ins?

If so, tick its check box, then click OK.

HansVogelaar_2-1693047736823.png

Hi Team, The following error appears when I attempt to analyze data despite the analyze data and pack being active:
We can't create suggestions from your data. Please assist

@Maysounalshaikh 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Hi Hans, I am able to share a snippet of the technical error, however there is no option to upload it to this chat. Do you have any recommendation or if you have an email address, I can send you an email.

@Maysounalshaikh 

Click on my username/user picture, then click Message. You should be able to attach the file to a private message.

Otherwise, you can send an email to   hans dot vogelaar at gmail dot com

Hi Hans, I have emailed you. Would you please check?

@Maysounalshaikh 

I have replied to your email.