Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to make an AddExpression clause work (StraightTable) and end up with the table "overcrossed".
After opening the object, and then closing it again, without any further action, the presentation is ok.
can anyone tell me what is causing this ?
set Graph = ActiveDocument.GetSheetObject("CH01")
x = Graph.AddExpression ("count(Team)")
Alex
i have the same issue using pivottable.
i'm trying to add an expression to a pivoit table using the following code:
ActiveDocument.GetSheetObject("chart2").AddExpression "count(distinct UnitItemID)"
but then get the "crossed" image on the pivot table.
If i edit the pivottable and simply click OK - the pivot works.
i guess additional properties needs to be set to the new expression, but i found no reference for how to do that.
Alex, have you found a solution for this issue ?
Hi yani...
I still have no solution to my problem, but I also stopped searching for one.
Seems the next release is offering features making the reason why I was using macros unnecessary.
Perhaps it is the same for you,
Alex