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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top