+ Reply to Thread
Results 1 to 4 of 4

slicers working in PC but not on Mac

  1. #1
    Registered User
    Join Date
    07-15-2018
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    2

    Unhappy slicers working in PC but not on Mac

    I have a PC and have built a dashboard by bulding pivot tables and charts that draw data from differernt tables (using table relationships). All the pivot are then connected to a single slicer.
    The dashboard is working fine on my system and also on my Colleagues who has a PC. My Boss however has a Mac and when he opens the flie, the slicer is non-functional. He is not able to click on the buttons within the slicer.


    Is there a solution to fix this? I spent a good 10-15 hours making the dashboard which is now useless since my Manager cannot use it on his Mac.

    Thanks

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: slicers working in PC but not on Mac

    Your data model is not going to work on a Mac.
    Rory

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

    Re: slicers working in PC but not on Mac

    To elaborate.

    Data Model and other related tools are only available for PC install of Excel, which includes data relationship. MAC version will lack these features.

    If you build your dashboard from single flat table using Excel range as source. That will work on both versions.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    03-11-2021
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    1

    Re: slicers working in PC but not on Mac

    If you need this for someone else to access/view the report and use the slicers, post the Excel File on One Drive and access it directly there. The slicers works for me on a Mac while doing so.

    Hope this helps.

    Cheers!

+ 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. Slicers not working in PowerPivot on Mac but do on Microsoft?
    By JCScott in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 02-11-2020, 03:40 AM
  2. Slicers not working
    By Jompje in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-01-2017, 08:39 AM
  3. Replies: 0
    Last Post: 02-13-2017, 01:18 PM
  4. Using Slicers
    By JakeMann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-29-2016, 08:52 AM
  5. Using Slicers
    By JakeMann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-29-2016, 08:50 AM
  6. [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
  7. RESOLVED: Working with Slicers - Pivot charts
    By uimhirADo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-29-2013, 04:13 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