Debra,

In my haste, I did not check which post this was regarding. I have answered
these questions but if you can refer to my post "Excel 2k Pivot Table refresh
scenario" this is my last hurdle in this macro. Looking forward to your reply.

GDCross

"Debra Dalgleish" wrote:

If you use the Show Pages command manually, do you get data on the
worksheets?
What code did the macro recorder produce?

To create the pivot charts, you can create some of the code by using the
macro recorder. Are you having problems with a specific part of the code?

GDCross wrote:
Question #1: I am trying to write VBA code to show pages from a pivot table.
The code from the macro recorder produces the worksheets, however, there is
no data in them and I don't know why?

Question #2: I need to write VBA code to generate PivotCharts off of these
Pivot Tables. Can anyone suggest any references for me?

Thanks in advance. GDCross


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html