Sub Macro1()
Dim vArr, rng As Range
Dim p As PivotTable
Set p = ActiveSheet.PivotTables("Tableau croisé dynamique1") ' adapter le nom
vArr = p.TableRange2.Value2
Application.ScreenUpdating = False
Sheets.Add
Cells(1).Resize(UBound(vArr, 1), UBound(vArr, 2)) = vArr
Set rng = Cells(1).CurrentRegion
NomTableau = InputBox("Nom du tableau?")
ActiveSheet.ListObjects.Add(xlSrcRange, rng, , xlYes).Name = NomTableau
End Sub