+ Reply to Thread
Results 1 to 1 of 1

ONE slicer disappear when data is removed (not all slicers) AND some faulty VBA code

  1. #1
    Registered User
    Join Date
    08-31-2022
    Location
    Stockholm
    MS-Off Ver
    Office 365
    Posts
    1

    ONE slicer disappear when data is removed (not all slicers) AND some faulty VBA code

    Hi,
    Ive created a workbook for entering data through a userform, printing the data in a Table, that is linked to a number of Pivot-tables and pivot-diagrams.
    The purpose of the workbook is to be able to enter data easily and that tha data will autotmatically be presented in the diagrams. Also, Ive created two slicers that enable me to choose what time period that should be presented in the diagrams.

    I did write the VBA code so that the first time I enter data in the model, if a Table doesn't already exist, it should be created. I tested this and it worked. Now - some additional work later, if I delete the table to "restart" it doesn't work anymore, I get an error message No 1004 saying that all worksheet data for a teble need to be on the same sheet as the table. Can I solve this fairly easily?

    Second problem, if I do a workaround, meaningly I don't delete the whole table but only the data in it, and then refresh ONE of my slicers disappear. I can understand if both of them would disappear since the data source (table) no longer has any data in it. But why does only one of the slicers disappear? The other one remains but is empty and when I add data to my table again, the choices in the slicers come back. Why doesn't both the slicers behave like this?

    Attached the workbook with some data in it

    BR
    Attached Files Attached Files

+ 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: 5
    Last Post: 05-13-2020, 09:28 AM
  2. Replies: 1
    Last Post: 06-12-2019, 03:48 PM
  3. Limiting slicer selection to 1 item for two different slicers
    By aalbarak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2018, 12:09 AM
  4. Slicers - how to update one slicer for all charts?
    By kreinking in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-06-2016, 03:35 PM
  5. Replies: 2
    Last Post: 05-12-2015, 03:46 PM
  6. [SOLVED] Pivot Slicers from multiple Caches - problem with 2nd Slicer displaying incorrect data
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2013, 03:06 AM
  7. Graphs Disappear With Linked Slicer?
    By excelnewbie123 in forum Excel General
    Replies: 2
    Last Post: 04-15-2011, 02:37 AM

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