copying sheet with pivottable without links/

[GangsterD]

Hello,

Ik have a file A.xls with sheet1: data and sheet2: pivottable

With a macro I copied the sheet2 to B.xls
With another macro I copied the sheet2 to sheet3 within the same workbook.

Problem:

I want to update the pivottable in sheet2(current sheet) without updating sheet 3. I tried using Data> Refresh (all) but that refreshes ALL sheets (sheet2 and sheet3)

OR I want to copy sheet2(current sheet) the exact way to a predefined sheet without the links to the database of A.xls

How do I define a macro to do either one of these things?

Kind Regards

 

[GlennUK]

If you want to take a snapshot of a pivot then copy and paste as values, like here:

http://blog.contextures.com/archives/2010/09/22/copy-pivot-table-format-and-values/