Tom,
I thought I'd send you a checklist of some things that I've tried before that have helped get the add-in loaded. Some you may have already tried, some may be things that you can try. Hopefully one of them gets it working for you.
A. Checking for disabled items in Excel
1. Open Excel, go to File->Options
2. On the Add-in page, there are 3 sections: Active, Inactie, and Disabled. Check which list the SAS Add-in appears in.
3. If it appears in the Disabled list, go to the "Manage" combo box at the bottom and choose Disabled Items, then click Go... Click on the SAS Add-In in the list of items to re-enable, and then Close.
4. Next, click on COM add-ins in that same combo box, and click Go... Check the checkbox next to the SAS Add-in and click OK. This should cause the add-in to load.
5. If it does NOT load, go back to File->Options->add-ins->COM addins->Go... In this dialog if you select the SAS Add-in, there will be a load behavior at the bottom. If there was an error during loading, it will put it here. This will let us know if Excel is at least trying.
B. Checking the registry directly
1. Run regedit (as the user who invokes office)
2. Navigate to the following key: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\SAS.ExcelAddin
3. See what the LoadBehavior is set to. You want it set to 3.
C. Reset your add-in registry settings with SwitcherUtility
1. From a command prompt, navigate to the directory where you have the Add-In installed.
2. Run: SwitcherUtility.exe ?
3. This shows a list of all the command line arguments. This has some extra options that are not available in the UI.
4. Run: SwitcherUtility reset // This will reset information in the current user portion of the registry. You want to do this as the user who is running Office, so that user's registry settings are reset, not the administrators.
5. See if this resolves the issue
6. Run: SwitcherUtility resetall // This will reset information in the local machine portion of the registry as well. You must be running as an administrator to do this.
7. See if this resolves the issue
8. Run: SwitcherUtility register // This will re-register the add-in assemblies
D. Are you in a virtualized environment? I've seen cases where each time a user logs in, their add-in gets disabled. This was because their registry was getting "reset" each time they logged in, and the values that were being reset had the add-in disabled. It doesn't sound like this is your case, but if it is, it's something to talk about with your system administrator.
E. Run the VSTO file
1. Go to the folder where you installed the SAS Add-in.
2. Find SAS.ExcelAddin.vsto
3. Double-click this file
4. This is essentially using the vsto file to register the add-in instead of our own process. I don't usually suggest this, but when nothing else seems to be working to get the add-in enabled, this will often give a more helpful reason for the failure.
Hopefully one of these strategies will do the trick. Feel free to contact me if you continue to have issues getting the add-in to load and I can take a closer look.
Tim Beese
... View more