Update Values in PivotTable

[AtomicWedgie]

Hello,

is it possible to update the values in a PivotTable without updating the data.

For instance I have a pivottable that shows values in EUR and I want to convert the values to USD using some kind of macro or so.

Regards,

Atomic Wedgie

 

[SkipVought]

Hi,

Not IN the PT --

Either in the SOURCE or

OUTSIDE of the PT.

You could, for instance, PT.copy/pastespecial-xlvalues and work on those results.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}