Every month I have to update numerous pivot tables which I then copy and paste into a new document to email to various people.
Is there anyway I can "unlink" a Pivot table from its data, thus turning it back into an ordinary spreadsheet for emailing.
Thanks.