page field

  1. D

    Can I index through a Pivot Table page field list? [Excel 2003]

    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?
  2. R

    Multiple Pivot Table Page Field Link to spreadsheet Cell (All) Exception

    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...
  3. C

    Pivot table page field with variable pivot items

    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...
  4. K

    Pivot Table Update

    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...
  5. R

    ChangeAllPivotHeaders

    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...
  6. G

    Pivot table Page field Name Switch

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top