add-in is not working in excel 2007

Topics: Resolved
Mar 17, 2008 at 5:29 AM
hi! i need help on how can i make this add-in works for my excel 2007.

i'm using windows XP "not vista" and microsoft excel 2007. I extract the zip file and run setup, I install this add-in on the default path: c:\Program files\Olap PivotTable Extensions\

When i open my olap pivotTable and right-click on the pivotTable no additional plugin is showing under the menu. I've tried to manually add the plugin through excel options but i always get an error " OlapPivotTableExtensions.dll is not a valid Office Add-in".

I really need this plug-in to work. Any help will be greatly appreciated.. Thank you!
Coordinator
Mar 17, 2008 at 3:03 PM
Edited Mar 17, 2008 at 4:38 PM
Hmm. Let's check the registry and see that everything there got registered as intended. What do you see at the following registry keys? And did you install for "Just Me" or for "Everyone"?

HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{EB6304F7-E7A3-4164-8BFA-E233A50941CC}
HKEY_LOCAL_MACHINE\Software\Classes\OlapPivotTableExtensions
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\User Settings\OlapPivotTableExtensions
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\OlapPivotTableExtensions
HKEY_CURRENT_USER\Software\Classes\CLSID\{EB6304F7-E7A3-4164-8BFA-E233A50941CC}
HKEY_CURRENT_USER\Software\Classes\OlapPivotTableExtensions

What version of the .NET framework do you have? What version of Visual Studio Tools for Office do you have? (Did the OLAP PivotTable Extensions installer prompt you to install VSTO or did you already have it?)

Also, can you describe the exact steps you took to "manually add the plugin"?
Mar 19, 2008 at 12:43 AM
1. This is what i have on the ff. registry keys:

HKEYLOCALMACHINE\Software\Classes\CLSID\{EB6304F7-E7A3-4164-8BFA-E233A50941CC}

>>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/1.jpg/IMG

HKEYLOCALMACHINE\Software\Classes\OlapPivotTableExtensions

>>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/2.jpg/IMG

HKEYLOCALMACHINE\Software\Microsoft\Office\12.0\User Settings\OlapPivotTableExtensions

>>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/4.jpg/IMG

HKEYCURRENTUSER\Software\Microsoft\Office\Excel\Addins\OlapPivotTableExtensions

>>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/3.jpg/IMG


2. What version of the .NET framework do you have? What version of Visual Studio Tools for Office do you have? (Did the OLAP PivotTable Extensions installer prompt you to install VSTO or did you already have it?)

- I have .NET 2.0 and VSTO 2005. The installer didn't prompt me to install VSTO because i already have it.

3. Also, can you describe the exact steps you took to "manually add the plugin"?

- i add the plugin through Customize quick access toolbar.
- under it i choose more commands and the excel options will open.
- i choose add-ins from the menu and this what i got >>>
IMGhttp://i122.photobucket.com/albums/o261/luciedlord/5.jpg/IMG
- under manage i choose com Add-ins then press Go.. and this is the result
>>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/6.jpg/IMG
- then i mark the checkbox nothing happened, so i press the add button and choose OlapPivotTableExtensions.dll
and this is the error i got >>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/7.jpg/IMG


thank you so much for the help..

Coordinator
Mar 19, 2008 at 2:03 AM
Unfortunately you didn't include a screenshot of the most important registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\OlapPivotTableExtensions

Regardless, go to the Office Button... Excel Options... Add-Ins... pick COM Add-ins from the dropdown... click Go... check OLAP PivotTable Extensions... click OK

I saw that you have OLAP PivotTable Extensions in that screen from one of your screenshots. That gives me hope that Excel knows about it, it just is inactive for some reason.

Another thing you might try as a last resort is uninstalling and reinstalling, but this time check the "Just Me" button so it only installs the add-in for you. The way that "Just Me" install sets the registry is very different than when you install for "Everyone".

Keep me posted. Thanks for all the good screenshots and info. We'll get to the bottom of this.
Mar 19, 2008 at 6:34 AM
here is the screenshot for HKEYCURRENTUSER\Software\Microsoft\Office\Excel\Addins\OlapPivotTableExtensions
>>> IMGhttp://i122.photobucket.com/albums/o261/luciedlord/8.jpg/IMG

when i check OLAP PvitoTable Extensions, nothing happens.

i'll just try to install and uninstall and see if there will be any changes.

thanks for the help



Mar 19, 2008 at 6:50 AM
Edited Mar 19, 2008 at 6:52 AM
i've installed the add-in in "Just Me" settings, but still its inactive in excel 2007. and if i try to add it manually the plugin is still not a valid add-in for excel 2007.

IMGhttp://i122.photobucket.com/albums/o261/luciedlord/9.jpg/IMG
Coordinator
Mar 19, 2008 at 6:07 PM
You've definitely already installed this version of VSTO SE? Any chance you should install it again in case something got corrupted?
http://www.microsoft.com/downloads/details.aspx?FamilyId=8315654B-A5AE-4108-B7FC-186402563F2B&displaylang=en

That registry entry looked right. I'm perplexed why it's not working.
Mar 24, 2008 at 2:53 AM

furmangg wrote:
You've definitely already installed this version of VSTO SE? Any chance you should install it again in case something got corrupted?
http://www.microsoft.com/downloads/details.aspx?FamilyId=8315654B-A5AE-4108-B7FC-186402563F2B&displaylang=en

That registry entry looked right. I'm perplexed why it's not working.



sorry for the late reply. i was away from my computer this last holy week vacation. i use that vsto se version. but i only installed the vstor.exe not the vstor.exe.manifest..

do i need to install both or just the vstor.exe.manifest?

thanks!
Coordinator
Mar 24, 2008 at 3:17 PM
You don't need to install the vstor.exe.manifest file.

I'm perplexed why it's not working. I'll keep you posted if I discover anything else. Please do the same.
Mar 24, 2008 at 11:43 PM
i hope we can fix it soon.. i dont want to add calculated member to my olap cube. ty..
Coordinator
Jun 27, 2008 at 10:48 PM
Release 0.5.2 should fix the problem. I think the problem was that when you installed Excel, you didn't install with the option checked to install .NET Programmability Support for Excel 2007. I changed the installer to install the necessary helper DLLs and not assume you've already got them.

Please let me know how it works for you.
May 20, 2009 at 9:30 AM
Edited May 21, 2009 at 5:10 AM

 

Hi. I have the same problem. I tried 3 PC configuration. Win xp pro x 86 with office pro 2007 - addin is OK. But I need work with Vista x 64 bussines and office pro 2007 – addin wrote " not loaded. A runtime error occurred during the loading of the COM Add-in". The same problem I have in win server 2003 x 64 and office pro 2007. The same problem I have in vista bussines x 86 and office pro 2007.Version olap is 0.6.2. PLS help. I can find no solution. THX Bart

 

Coordinator
May 20, 2009 at 7:07 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
May 20, 2009 at 7:13 PM

Can you try the troubleshooting steps described above? Can you uninstall and reinstall and tell me exactly what settings you pick (like whether you install for all users or for just yourself) and what path you pick (i.e. c:\Program Files or c:\Program Files (x86)).

I have installed this add-in on a 64-bit server and it worked fine.

I haven't tried installing on a Czech box. That could be the problem. If anyone has installed on an Excel installation that's not English, post back here, please.

Coordinator
Oct 3, 2009 at 5:32 PM
Edited Oct 3, 2009 at 5:34 PM

I have been doing some research about install problems, and have posted a few tips on the Troubleshooting Installation page. Please post back if any of those tips help.

Coordinator
Jun 2, 2010 at 8:52 PM

I've just release a new installer (version 0.7.0) which is completely revamped. The driving reason behind this was getting one codebase that would sucessfully install for Excel 2007 and Excel 2010... and to get an installer that would work for the new 64-bit Excel 2010.

Anyway, please try this new installer and let me know if it fixes your problem. Let me know how it goes.

Marked as answer by furmangg on 6/10/2014 at 3:26 PM