Hello,
I need to refresh the pivot table depending of the ActiveDocument.GetApplication.InputBox statement in a module.
I tried to insert an expression (ex. [Sales Amount] > Variable) in the Calculation Condition text box but nothing happens.
I would expect to see the pivot table contents filtered by the above condition depends of the user input.
Is it possible?
Thanks in advance.
Best regards