Recent content by davecrt

Naray i'm obliged!! Thank you very much!!! The code works perfectly!! Really appreciated My bests Davide

Option Explicit Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) On Error Resume Next Dim wsMain As Worksheet Dim ws As Worksheet Dim ptMain As PivotTable Dim pt As PivotTable Dim pfMain As PivotField Dim pf As PivotField Dim pi As PivotItem Dim bMI As Boolean On Error Resume...

Naraya probably the problem could also be related to the fact that i have a macro that allow to update all pivot tables within the sheet in a coordinated way. the code is here Option Explicit Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) On Error Resume Next Dim wsMain As...

For the code, i do not have to also declare what is the event that should trigger the code? (i mean, let excel understand that the option must be activated after pivot refresh?)

Hi Naraya Where is the code placed? I do not see it in the sheet

Yes Narayan. I have excel 2007 too but the file i sent you is simplified. consider that the pivot chart does not retain the formatting each time. how i can teach to excel via macro to get the "invert if negative "option checked after each time pivot table is refreshed??

Sure,here i have attached the file. As you can see in the chart both bars at left and right are green. As solution, i choose the data series option, then do select "invert if negative" option, with four steps and two colour (the settings already in place with the gradient option are founded on...

No, it does not concern preserve formatting options. It is checked. It is a problem with the lose of formatting. specifically: I have "invert if negative" option checked in a pivot chart, but as soon as i choose another filter value the option get unchecked automatically.. I think need a macro...

Dear All Another issue with pivot table a pivot chart lost its data series formatting settings after i refresh the linked pivot table or i choose a different value in the filter value area. Looking in the forums it looks like it is a well know issue fromm Microsoft. However, someone here has...

Jake, really an easy solution that when comes friday evening i'm not able to see.. Thanks a lot, really appreciated Dave

Hi Bob data bars in excel 2010 do not make distinction between positive and negative data values. While in 2013 and 2012 version the bar go from left to right or right to left depending if the values is a positive or negative one, becoming also red if the values in sengative or green if...

Hi at all my dear friends Another wounderfull challange to share with you I have a range of both positive and negative values I would get as result that, if values is negative, then the colour scale should be different gradient of red, with intensinty increasing at bigger negative values...

Correct. But with slicers you are able to get that result reducing the filter2 list of available values under certain filter1 values. Then, mining the web till know any solution found. But,as in my case, if we say filter2 has hundred of values available, that should be reduced to few one in...

It is nto altering. I think that should be normal the fact that, if under a filter1 value, for instace X, are available only two values for the filter2, say B and C, then the dropdown list of filter2 should only display B and C, and not also, say D (hypothesis that filter2 available values are...

Good day dear. Unluckly not, excel is version 2007. However the issue is easy. I want as result that, if i choose one value within the first filter in the "report filter" area, then, as result, if i choose to utilize a second filter in the report filter area(for filter i mean "data field"...