Hi,
Prior to today (WED 08/23/17) if I had a worksheet with a pivot table on it, formatted, etc, and wanted to email it out w/o the pivot functions, I could highlight the entire worksheet (click corner button to the left of A, and above 1), Ctl+C, right-click in cell A1, then Paste-Special...