+ Reply to Thread
Results 1 to 9 of 9

Unable to get the pivottables property of the worksheet class

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Unable to get the pivottables property of the worksheet class

    Good morning,

    I double checked Chart 5 and WinChill and verified that they are the correct names. However, i'm still coming up with this error.

    Any suggestions?

    Please Login or Register  to view this content.
    Debugger says error is occurring at -
    Please Login or Register  to view this content.
    Thanks,

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Unable to get the pivottables property of the worksheet class

    Does it make any difference if you replace this:

    Please Login or Register  to view this content.
    with this:

    Please Login or Register  to view this content.
    Rory

  3. #3
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Re: Unable to get the pivottables property of the worksheet class

    No, still get the same error.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Unable to get the pivottables property of the worksheet class

    Then either the name of the pivot table is wrong, or there's some other code being triggered by the refresh of the pivot cache. Can you post the workbook?

  5. #5
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Re: Unable to get the pivottables property of the worksheet class

    Does it make a difference if the button, the chart and pivot table are on different sheets but still on the same workbook?

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Unable to get the pivottables property of the worksheet class

    Nope. As long as the pivot table is on the Dashboard sheet, and the name is correct, you wouldn't get that error.

  7. #7
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Re: Unable to get the pivottables property of the worksheet class

    Quote Originally Posted by rorya View Post
    Nope. As long as the pivot table is on the Dashboard sheet, and the name is correct, you wouldn't get that error.
    Oh, they are on separate sheets. PivotTable is huge and I wanted to keep the Dashboard Sheet clean with just charts.

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Unable to get the pivottables property of the worksheet class

    That's why your code fails then. You're referring to a pivot table called WinChill on the Dashboard sheet. Change the sheet reference.

  9. #9
    Registered User
    Join Date
    04-16-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2013
    Posts
    50

    Re: Unable to get the pivottables property of the worksheet class

    Quote Originally Posted by rorya View Post
    That's why your code fails then. You're referring to a pivot table called WinChill on the Dashboard sheet. Change the sheet reference.
    Silly mistake, thanks rorya! Works great now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-10-2017, 10:02 AM
  2. Run-time error 1004: Unable to get the PivotTables propert of the Worksheet class
    By Netzqua in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2016, 02:14 PM
  3. [SOLVED] Unable to get the CheckBoxes Property of the WorkSheet class
    By Controller 99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2015, 07:42 AM
  4. Unable to set the Visable property of the Worksheet class
    By ConradRichard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2013, 03:34 PM
  5. Unable to set the visible property of the worksheet class
    By colinnwn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2009, 03:48 PM
  6. Unable to get the dropdowns property of the worksheet class???
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-22-2006, 06:24 PM
  7. Run-Time error '1004: Unable to get the PivotTables property of the worksheet class
    By magarnagle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2006, 06:20 AM

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