Error to access Calculations Library

first post: Mathieu44 wrote: Hello, I install the Add-In on my PC (Window7). All is OK during t...

latest post: furmangg wrote: You might also look at this old issue with someone experiencing the...

Enable/Disable AutoRefresh via Macro

first post: phillipc wrote: Is there a way to configure a macro to accomplish the above? I've t...

latest post: furmangg wrote: If you look at the code (which is in C#) you will see a cmdDisableA...

answered by: furmangg wrote: If you look at the code (which is in C#) you will see a cmdDisableA...

Clear Pivot Cache with multiple tables on single connection

first post: egilegil wrote: Hi, in our project we are using pivot tables connected to OLAP sour...

latest post: egilegil wrote: Hi, in our reports we have a global "filter" for organization (as i...

Extend the Calculation Dialog

first post: meyerjo wrote: is it possible to extend the Calculation Dialog:for examplesee http...

latest post: furmangg wrote: Excel 2013 includes a calculation editor. I won't enhance mine by a...

answered by: furmangg wrote: Excel 2013 includes a calculation editor. I won't enhance mine by a...

Calculated Members

first post: ezhara wrote: Hi, I've been trying to create a calculated member in excel 2007 v...

latest post: furmangg wrote: The [All] is telling it that the new calculation should be a child ...

answered by: furmangg wrote: The [All] is telling it that the new calculation should be a child ...

Pivot Table multiple filters

first post: mtaylor wrote: Hi, I'm working with a complex pivot table that references a cube, ...

latest post: furmangg wrote: https://olappivottableextend.codeplex.com/wikipage?title=Filter%20L...

answered by: furmangg wrote: I guessed that the "Defer Layout Update" button might help, but che...

Returns "#VALUE!" if member contains ' - '

first post: SaintNicolas wrote: Hi,Very nice tool! For your info : I noticed that when a measure in...

latest post: furmangg wrote: There is also a feature in this add-in to help you see the #VALUE! ...

answered by: furmangg wrote: Can you capture the MDX query and run it in Management Studio? Afte...

Showing Measures in Calculation Tab Of OLAP PivotTable Extensions

first post: sriniRk wrote: Is there any way to show all measures in calculation tab when we op...

latest post: furmangg wrote: Excel 2013 added this feature natively.

answered by: furmangg wrote: Excel 2013 added this feature natively.

# VALUE when using AGGREGATE() against PowerPivot

first post: ruve1k wrote: I created a simple table (named Table1) for testing as follows:Lett...

latest post: furmangg wrote: Also consider this feature to see the error behind #VALUE! cells: h...

answered by: furmangg wrote: Also consider this feature to see the error behind #VALUE! cells: h...

Request New Functionality (2)

first post: superbluesman wrote: Hello! Can You do the following: The ability to group (and sav...

latest post: furmangg wrote: Excel 2013 has a feature that will help with your #2 request. Drop ...

answered by: furmangg wrote: Excel 2013 has a feature that will help with your #2 request. Drop ...