Help required with setting up a pivot table with the source on sheet1 to have the pivot table create

D

Diana

Try using the actual location:
TableDestination:="[YourWorkbookName]Report!R3C1"

As opposed to:
TableDestination:=""

I hope this helps.

-----Original Message-----
How would I have to change this code so that the pivot
Click to expand...
table is created on the sheet named "Report" within the
active workbook?
ActiveWorkbook.PivotCaches.Add
Click to expand...
(SourceType:=xlDatabase, SourceData:="data"). _
CreatePivotTable TableDestination:="", TableName:="PivotTable1"
ActiveSheet.PivotTableWizard
Click to expand...
TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveSheet.PivotTables("PivotTable1").SmallGrid = False
ActiveSheet.PivotTables("PivotTable1").AddFields
Click to expand...
RowFields:=Array("PDWK", "WK - HM Store", _
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Macro with dynamic source data 1
Format Pivot total rows 2
VBA Pivot Table Error 1
Avoiding an extra sheet when creating a pivot table 3
Pivot table help 8
Pivot table 2
Playing back a Pivot Table macros 2
Pivot table Macro help!!! 3

Top