+ Reply to Thread
Results 1 to 1 of 1

Command Button to reset PivotTable Fields to "Show All" - Run Time Error 1004

  1. #1
    Registered User
    Join Date
    02-17-2012
    Location
    Grandville, MI
    MS-Off Ver
    Excel 2003
    Posts
    1

    Command Button to reset PivotTable Fields to "Show All" - Run Time Error 1004

    I've seen a few forum posts on this but the suggestions are still not working for me. I've attached a smaller version of my spreadsheet. I'm pulling data from "Data Entry" and the PivotTable is on "Full Query". I would like to use the command button to have it reset all the PivotFields but keep getting the error "Unable to get PivotItems property from the PivotField class".

    I'm hoping someone can look at the code below that I have in there and also my spreadsheet to figure out what I'm doing wrong.

    Thanks ahead of time!



    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Mordred; 02-17-2012 at 01:54 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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