OLAP Pivot Table Menu is not appearing

Hello, I just installed the extension on a 2007 version of Excel. The add-in is now appearing in the "Excel Options > Add-Ins" but when I right-click on a pivot table to see the "OLAP Pivot Table....

Id #63711 | Release: None | Updated: Jul 15 at 11:50 AM by furmangg | Created: Jul 15 at 8:47 AM by Followit

Posting VBA version here

Here is my port of code to VBA. Please move to the appropriate place on the site. I use this in Excel 2013. I could not get the "ActiveWorkbook.Connections.Add2" code to work reliably and haven't ...

Id #63563 | Release: None | Updated: Jun 15 at 4:51 PM by TheRizza | Created: Jun 15 at 4:51 PM by TheRizza

Clear PivotTable Cache and KPIs

Create a PivotTable that includes multiple KPI status or trend indicators. Clear PivotTable Cache. (The KPI icons are blanked out, but that's expected because we blanked out the MDX script temporar...

Id #26046 | Release: None | Updated: Mar 20 at 5:55 PM by furmangg | Created: Mar 20 at 5:55 PM by furmangg

Installation Error Office 2013

Previously, this plug-in worked Office x64 via O365 on Windows 8.1 Error reported in Message Box Problem during startup of OLAP PivotTable Extensions: The given key was not present in the dictio...

Id #25788 | Release: None | Updated: Oct 20, 2014 at 3:18 PM by furmangg | Created: Oct 20, 2014 at 3:17 PM by furmangg

Exact match search with multiple search terms is slow

In forthcoming release 0.8.4 with non exact match searches for lots of search terms, it will detect it's faster to search on the client. But this optimization doesn't apply to exact match searches....

Id #25642 | Release: None | Updated: Aug 1, 2014 at 9:23 PM by furmangg | Created: Aug 1, 2014 at 9:23 PM by furmangg

Plug-in crashes excel 2013 64-bit

With the add-on install, if excel is launched it runs into an error that causes a crash. I have updated all windows updates, tried repairing office 2013, have uninstalled and re-installed the exten...

Id #25501 | Release: None | Updated: Feb 13 at 3:31 PM by SebT | Created: May 26, 2014 at 8:08 PM by scompto

On Excel startup, error with a dictionary key

Hello, At the startup of Excel, I have an error with the Olap Pivot Table Extensions Add-In : a key is missing. I don't have no error during the Add-In installation. I tried to desinstall on rei...

Id #25482 | Release: None | Updated: May 19, 2014 at 4:51 AM by PGeiger | Created: May 18, 2014 at 9:13 PM by PGeiger

The connection either timed out or was lost

This error seemed to crop up with we changed from the 2008 version of msmdpump.dll to the 2012 version. I can't verify as i can't get it to work period on either version. Is there a hardcoded url...

Id #25137 | Release: None | Updated: Jan 30, 2014 at 3:41 PM by dodom | Created: Jan 27, 2014 at 6:25 PM by dodom

Error message when you right click on a dimension member on rows with Defer Layout Update on

Error: Problem setting up Show Property as Caption The PivotTable report cannot be edited with the Defer Layout Update check box selected. To edit the report, clear the Defer Layout update check bo...

Id #24752 | Release: None | Updated: Oct 2, 2013 at 10:18 PM by furmangg | Created: Oct 2, 2013 at 10:18 PM by furmangg

Export search results function

chjone suggested: Is it possible to export the search results? On the search tab, I select 'Field List' in the Look in drop down and hit find next...it lists everything...which is perfect. I can ...

Id #24186 | Release: None | Updated: Apr 18, 2013 at 1:03 AM by furmangg | Created: Apr 18, 2013 at 1:03 AM by furmangg