Search results

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...

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...

Hi at all guys Issue: I have a pivot table with multiple filter in the Report filter Area. If I choose a value for the first filter in that are, i was expecting that the available choice list of the second filter would have been restricted to the values available under the first filter choice...

Hi guys. As mentioned in the title i get many pivot table to get their headers became black after i choose different filter values. I have the option "autofit column width on update" unchecked and "preserve cell formatting on update" checked. So what could be the issue? Till no no found any...

Pivot Table Memory Issue - Excel crashes Excel crashes when a refresh is performed just after a adding new column to the initial data source. Source data for the pivot table is on another worksheet within the same workbook. Any tips or suggestion? best at all Davide

Hi at all guys Ermgency. I need to understand rapidly if it is possible at all to filter error values in a pivot table; hiding row values that contain errors values in some data column please help best davide

Hi ar all guys Someone is able to explain to me if at all is possible to apply conditional formatting to a calculated field withina pivot table, in the manner that when the table updates slso the consit form applied to the calcul field data do the same?? Till now only pure data field accept...

Hi guys. First of all thanks for your attention. Easy question I'm using this syntax in excel power pivot table =DISTINCT(ALL(Table2[sedi]) to get as result all the unique values that the field "sedi" displays, despite filters applied in the corresponding pivot table But i got as result...

Guys, hard problem, need help I must report all the cells from a previous sheet that respect a particular condition, otherwise consider the cell like blank. the problem is that this must be automatic, in the sense that i need that this operation devolps every time with different records sheet...