Hello,
I hope you can help me with a Pivot Table created with VBA code pulled from "VBA and Macros for Excel 2007" book.
My problem is that the table is created but does not displaying any values.
If I select the pivot table and use the Pivot Table Tools menu and click on the +/- button under the Show/Hide section it displays properly.
I went over the code and checked out the CreatePivotTable method in help but I must be missing something, not sure where to go for the code to toggle +/- button with code.
Sorry for the rookie question but any help would be appreciated (they got me on a deadline)!
I hope you can help me with a Pivot Table created with VBA code pulled from "VBA and Macros for Excel 2007" book.
My problem is that the table is created but does not displaying any values.
If I select the pivot table and use the Pivot Table Tools menu and click on the +/- button under the Show/Hide section it displays properly.
I went over the code and checked out the CreatePivotTable method in help but I must be missing something, not sure where to go for the code to toggle +/- button with code.
Sorry for the rookie question but any help would be appreciated (they got me on a deadline)!
