Results 1 to 18 of 18

Macro to toggle Pivot - Collapse/Expand entire field

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-24-2008
    Location
    Athome
    MS-Off Ver
    Excel 2013
    Posts
    127

    Macro to toggle Pivot - Collapse/Expand entire field

    Hey guys

    Need your help with VBA and pivottables.

    I want to select a field in a pivottable, and then be able to click a macro button to toggle the "collapse/expand" entire field. I need a way to reference the pivot field represented by the cell that has been selected.

    (Post edited and removed unnecessary info).
    Last edited by rasonline; 08-06-2017 at 02:39 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Collapse expand Pivot
    By EXLent in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 03-15-2016, 06:08 PM
  2. [SOLVED] Adapting VBA code to alow use of expand/collapse field on a pivot table
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2015, 07:37 AM
  3. Multiple Collapse/Expand - Pivot Table Field List
    By pattyjay in forum Excel General
    Replies: 2
    Last Post: 09-17-2015, 04:37 PM
  4. Expand/Collapse Entire Items in a Field in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 5
    Last Post: 06-08-2015, 07:52 AM
  5. [SOLVED] Pivot T Problem w/Expand-Collapse all PTs
    By catnam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-22-2014, 08:46 AM
  6. how to stop Expand Entire Field when Refresh pivot table
    By ttulinsky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-03-2013, 01:02 PM
  7. macro to expand and collapse a pivot field failing.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2010, 02:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1