I posted this question in the BigFix Excel Topic Connector, BigFix Excel Connector , as well but noticed it had not been updated in several months so I figured I would try here too.
If anyone has used this Excel ad-in before for Excel 2016 and gotten it to work could you explain how you did so? I have installed the add-in and under COM add-ins it shows that it is loaded. But I cannot tell that it has changed anything and I cannot figure out how to run BigFix Connector.
Open a new blank worksheet and you should see “IBM Bigfix” in the top menu. Click on that to access the connector features. This from a machine I just installed v3.3.8 on that is running Excel 2019
I believe the check box should be checked though yours looks a bit strange in that the location isn’t reflecting the filename I see in mine (I installed to the default path so its bound to my user profile)
Do you have permission to access the folder its installed to? Maybe Excel defaults to a different DLL if it can’t acces the path/file of the COM add-in
That may be the issue or maybe something in group policy is preventing me from using the add-ins. I thought it was odd, but when I click the check box, hit ok, and relaunch excel, the check box is no longer checked. I’ll check that out and then update this when I find out.
While waiting to hear back about group policy, I tried adding the add-in from the installation location like in your screenshot but doing that it tells me that dll isn’t valid. Maybe I’ll need to wait for a future version release?
I tried this method and it still is not giving me the BigFix IBM tab. I was told that we typically do prevent add-ins from functioning so i’m assuming that is the reason for the issues i’m having. If i ever find out anything different I will update this.
I’ve used it for years without any issues, but there was an older version that I had issues getting to work in 2016 and i’m wondering if that is your issue also.
