Data analysis tool pack

%3CLINGO-SUB%20id%3D%22lingo-sub-1284708%22%20slang%3D%22en-US%22%3EData%20analysis%20tool%20pack%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1284708%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20to%20add%20analysis%20tool%20pack%20to%20my%20excel%20sheet%20i%20followed%20the%20steps%20but%20still%20nothing%20is%20shown%20under%20data%20bar%20and%20i%20tried%20to%20close%20it%20are%20reopen%20it%20again%20and%20do%20the%20same%20thing%20but%20still%20it%20did%20not%20show.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1284708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1624057%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20analysis%20tool%20pack%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610994%22%20target%3D%22_blank%22%3E%40nada2490%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooks%20like%20no%20one%20got%20back%20to%20you.%20I%20am%20in%20the%20same%20boat%20and%20not%20a%20single%20web%20site%20on%20the%20internet%20shows%20what%20to%20do%20if%20followed%20the%20status-quo%20steps%20and%20still%20we%20don't%20see%20the%20DATA%20ANALYSIS%20button.%20In%20fact%20I%20have%20tried%20a%20couple%20of%20ways%20to%20an%20unsuccessful%20end.%20MAybe%20this%20will%20help%20you%2C%20while%20I%20wait%20for%20the%20the%20experts%20here%20for%20my%20problem%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E---------------------%3C%2FP%3E%3CP%3EI%20need%20some%20help%20in%20adding%20an%20Excel%20add-in%20called%20DATA%20ANALYSIS%20Tool%20pack.%3C%2FP%3E%3CP%3EI%20have%20Microsoft%20Office%20Professional%202016.%3C%2FP%3E%3CP%3EI%20performed%20the%20following%20steps%20in%20an%20attempt%20to%20load%20the%20DATA%20ANALYSIS%20pack.%3C%2FP%3E%3CP%3E1.%20Go%20to%20FILE%20--%26gt%3B%20OPTIONS%3CBR%20%2F%3E2.%20On%20the%20ADD-INS%2C%20I%20select%20EXCEL%20ADD-INS%2C%20click%20GO%3CBR%20%2F%3E3.%20I%20selected%20ANALYSIS%20TOOLPAK.%20(In%20the%20second%20trial%2C%20I%20also%20added%20ANALYSIS%20TOOKPAK%20-%20VBA%20but%20no%20change)%3CBR%20%2F%3E4.%20Click%20OK.%3CBR%20%2F%3E5.%20Excel%20'acts'%20like%20it%20acknowledged%20my%20addition%20of%20the%20toolpak.%3CBR%20%2F%3E6.%20I%20restart%20Excel%2C%20and%20go%20to%20DATA%20tab.%20And%20I%20Still%20don't%20see%20the%20DATA%20ANALYSIS%20ribbon%20there%20or%20the%20DATA%20ANALYSIS%20button.%3C%2FP%3E%3CP%3EI%20performed%20the%20above%20steps%20so%20many%20times%20but%20to%20an%20unsuccessful%20end.%3C%2FP%3E%3CP%3EThen%20tried%20the%20following.%3C%2FP%3E%3CP%3E1.%20FILE%20--%26gt%3B%20OPTIONS%20--%26gt%3B%20TRUST%20CENTER%3CBR%20%2F%3E2.%20Click%20on%20TRUST%20CENTER%20SETTINGS%3CBR%20%2F%3E3.%20Click%20on%20TRUSTED%20ADD-IN%20CATALOGS%3CBR%20%2F%3E4.%20In%20the%20CATALOG%20URL%2C%20I%20entered%20the%20complete%20path%20to%20where%20the%20file%20%22ANALYS32.XLL%22%20exists.%3CBR%20%2F%3E5.%20Click%20OK%3C%2FP%3E%3CP%3ERepeat%20the%20process%20of%20closing%20Excel%20and%20reopening%20and%20I%20still%20cant%20see%20the%20DATA%20ANALYSIS%20button.%20One%20thing%20I%20should%20say%20here%20is%20that%2C%20my%20admin%20has%20blocked%20access%20to%20this%20Trust%20Center.%20So%2C%20although%20I%20feel%20that%20I%20added%20it%2C%20and%20I%20click%20OK%2C%20I%20go%20back%20and%20the%20URL%20is%20not%20there.%3C%2FP%3E%3CP%3EReally%2C%20the%20first%20set%20of%20steps%20are%20what%20I%20found%20out%20on%20most%20web%20sites%20to%20be%20working.%20But%20in%20my%20case%2C%20frustratingly%2C%20not%20working%20at%20all.%3C%2FP%3E%3CP%3EAny%20ideas%3F%20I%20would%20really%20appreicate%20if%20you%20give%20me%20your%20thoughts%20on%20this.%20I%20am%20avoiding%20contacting%20my%20admin%20which%20is%20a%20long%20and%20painful%20process.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

I have tried to add analysis tool pack to my excel sheet i followed the steps but still nothing is shown under data bar and i tried to close it are reopen it again and do the same thing but still it did not show.

1 Reply
Highlighted

@nada2490 

Looks like no one got back to you. I am in the same boat and not a single web site on the internet shows what to do if followed the status-quo steps and still we don't see the DATA ANALYSIS button. In fact I have tried a couple of ways to an unsuccessful end. MAybe this will help you, while I wait for the the experts here for my problem?  

---------------------

I need some help in adding an Excel add-in called DATA ANALYSIS Tool pack.

I have Microsoft Office Professional 2016.

I performed the following steps in an attempt to load the DATA ANALYSIS pack.

1. Go to FILE --> OPTIONS
2. On the ADD-INS, I select EXCEL ADD-INS, click GO
3. I selected ANALYSIS TOOLPAK. (In the second trial, I also added ANALYSIS TOOKPAK - VBA but no change)
4. Click OK.
5. Excel 'acts' like it acknowledged my addition of the toolpak.
6. I restart Excel, and go to DATA tab. And I Still don't see the DATA ANALYSIS ribbon there or the DATA ANALYSIS button.

I performed the above steps so many times but to an unsuccessful end.

Then tried the following.

1. FILE --> OPTIONS --> TRUST CENTER
2. Click on TRUST CENTER SETTINGS
3. Click on TRUSTED ADD-IN CATALOGS
4. In the CATALOG URL, I entered the complete path to where the file "ANALYS32.XLL" exists.
5. Click OK

Repeat the process of closing Excel and reopening and I still cant see the DATA ANALYSIS button. One thing I should say here is that, my admin has blocked access to this Trust Center. So, although I feel that I added it, and I click OK, I go back and the URL is not there.

Really, the first set of steps are what I found out on most web sites to be working. But in my case, frustratingly, not working at all.

Any ideas? I would really appreicate if you give me your thoughts on this. I am avoiding contacting my admin which is a long and painful process.