Reset edited Member Names

first post: MikeHoney wrote: There is a little-known (perhaps even undocumented) feature of Exce...

latest post: SCornille wrote: Idem j'ai la même problématique et cela pourait être intéressant .....

answered by: furmangg wrote: That's a great suggestion. I've run into this confusion many times ...

Setting dimension filter took much time

first post: ils wrote: Is it correct that setting filter values on "Filter list" tab took ...

latest post: furmangg wrote: I'm glad it's faster when you search for a lot of search terms and ...

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.