+ Reply to Thread
Results 1 to 2 of 2

PowerPivot: Can't add slicer to Pivot Table

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    PowerPivot: Can't add slicer to Pivot Table

    I've got a Pivot Table that is pulling data from PowerPivot and for some reason it won't insert a slicer. I select the slicer I want and when I click OK, nothing happens. I've checked the data source and everything seems to be working fine. One other thing to note. If I have an old slicer and I try to connect it to my new Pivot Table, I get the following error: "This PivotTable report is invalid. Try Refreshing the data."

    Any thoughts?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: PowerPivot: Can't add slicer to Pivot Table

    Try going in to PowerPivot data model and refresh connection to source.

    Ensure Slicer column is in there and has valid values.

    I assume slicer is either a column within same table or related table within the model.

    Sounds like data model changed from when old slicer was created and tool is unable to make connection to new pivottable.

+ 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. Pivot Table and Slicer Help
    By matt85webb in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-28-2016, 11:14 AM
  2. Pivot table and slicer help
    By finchfinch in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-23-2016, 07:36 AM
  3. Replies: 19
    Last Post: 04-04-2016, 02:58 PM
  4. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  5. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  6. [SOLVED] Use slicer selections on one pivot table to filter another pivot table
    By porkandbeans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2013, 12:30 AM
  7. Pivot Table (Slicer) Help
    By skate1991 in forum Excel General
    Replies: 0
    Last Post: 10-11-2012, 11:52 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