So I am fairly new to excel and I was trying to use a program that I usually use on my other computer but it doesn't work on my new one. It might be because my other computer had an older version of excel. But after I try and click a button on my excel program (picture shown) it gives me the message shown in my linked pictures. If anyone has any fix for this it would be greatly appreciated as I need this program for work. Thank you
ATPVBAEN is the VBA Analysis Tool Pak. It is an Excel add-in. It is normally installed as part of the Excel installation, and then you have to enable in Options - Add-Ins.
Mine is installed at
C:\Program Files\Microsoft Office\root\Office16\Library\Analysis
which I think is the default.
Go to File, Options, Add-ins, and at the bottom where it says "Manage:" select Excel Add-Ins and click Go. If you do not see "Analysis Toolpak - VBA" listed then you will have to install it. You can either repair your installation of Excel (I don't know what version you mean by "2020") or you can download the attached and install that.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
It's not included in Excel for Mac to the best of my knowledge.
Rory
Attachment 720165
Hello, I checked and I actually already had it checked. I'm not sure if this matter but as you can see from the image it just says analysis toolpak and not the VBA. Is there any other possible problems or should I try and redownload?
Thank you!!
There are two, and the one giving you the error message is the VBA one. So it looks like you don't have it.
Per rorya's comment, what OS are you on? I don't recognize "2020" as an Excel version.
toolpak.jpg
I'm assuming Mac, based on the path shown in the screenshot in the first post, but 2020 isn't a Mac version either.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks