page field

I've created a pivot table and I'd like to index through each "value" in the page field and then copy the results to another sheet, one sheet per field returned. I can't figure out if it's possible to index through the list though. Is it possible?

How do I make this work? I found this code online but it does not work for the section that deals with the exception for <>target.value that should force the pivots to equal (All). Here is the section: If pf.CurrentPage <> Target.Value Then pf.CurrentPage = "(All)" End If If pf2.CurrentPage...

I have a pivot table that I want to hide all the pivot items in the page field except (blank). Since the pivot items are subject to change, I don't want to select them by name or array. This code I'm using gives me a run time error 1004: Unable to set the Visible property of the PivotItem...

I have created a pivot table based on data in a different file. The pivot table includes a Page Field that is usually a number between 1 and 12. In the data file, I recently changed the numbers to Jen1, Jen2, Jen3, etc. I refreshed the pivot table and the Page Field correctly displayed the...

Here is the code: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Sub ChangeAllPivotHeaders()<o:p></o:p> Dim SPgField As String<o:p></o:p> 'must keep cursor on page field<o:p></o:p> SPgField1 = Selection<o:p></o:p> Dim Pt As PivotTable<o:p></o:p> Dim Wsht...

I have a macro that accidentally tried selecting a page field (New York) item that didn't exist. This renamed the currently selected page field (Alabama) to the value I tried to select (New York). I now have 3 or 4 values that are now wrong. Is there a way to refresh these pivot table values...