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


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

Some videos you may like

This Week's Hot Topics