If it's a one-time thing, I just cut and paste values
Return to Back Room
Show All Thread
In reply to:
calling Excel Studs and Studettes
posted by vivaflanner
for the whole pivot table on a new sheet.
If it's something I'll use again, I'll use SUMIF instead of a pivot table.
ive been doing the cut and paste
Keep the pivot table and replace the underlying data
The contents of this post represent the views of the author. NDNation.com is not responsible for its contents.