+ Reply to Thread
Results 1 to 3 of 3

Changing Names of Slicers is Prompting an Error

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Changing Names of Slicers is Prompting an Error

    Hello again. I'm getting an error (end/debug) message thrown when I change names of the slicers, both in the Data sheet and on the Slicer itself, and then try to update the PT or Reset the PT.
    The error is showing on Sheet2 (BuildMyBOM). Select any of the Items to the left and then select Reset. The line that is being highlighted is:
    If Not ActiveWorkbook.SlicerCaches(SlicerName).SlicerItems.Item(1).Value = "N/A" Then
    I’ve updated the Data sheet, I’ve updated the slicers, I’ve updated the code to the best of my abilities. I’m not sure where I’m going wrong. Would greatly appreciate if someone could take a look at it for me and provide some insight. Tks.
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Changing Names of Slicers is Prompting an Error

    Maybe explain what you are trying to achieve with the macro?

  3. #3
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Re: Changing Names of Slicers is Prompting an Error

    I was only trying to change the names of the slicers. Rating became Class/Rating. Class became Approvals. Requirements became Special Req. I changed it on the Data sheet. Then I changed the slicer name. Then I changed the macro. Basically update one, update the rest. After changing the names, the Macro no longer works...or rather it works, but with an End/Debug message. When you view the code, the below line is highlighted.
    If Not ActiveWorkbook.SlicerCaches(SlicerName).SlicerItems.Item(1).Value = "N/A" Then
    So, I'm trying to figure out what I need to do to make it start working again. If I change the slicer names back, it works fine, but I kinda need to make these changes. So, that's where I'm at with it. I also tried refreshing the PT and inserting new Slicers. Still not working. Tks.

+ 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. [SOLVED] Changing array names creates error
    By itsunclebill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2015, 01:47 AM
  2. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  3. Replies: 1
    Last Post: 03-27-2014, 02:08 PM
  4. Replies: 9
    Last Post: 02-24-2014, 06:12 PM
  5. Changing Sheet Names based on cell value - Object doesnt support this property error
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 09:30 AM
  6. how to get "prompting of names" in a cell while entering data in excel07
    By cvsuryam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2011, 05:26 AM
  7. Replies: 1
    Last Post: 12-02-2007, 12:51 PM

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