+ Reply to Thread
Results 1 to 4 of 4

Excel 2019 workbook with slicer won't work in Excel 2010 - help please

  1. #1
    Registered User
    Join Date
    05-19-2019
    Location
    Sunderland
    MS-Off Ver
    2007
    Posts
    5

    Question Excel 2019 workbook with slicer won't work in Excel 2010 - help please

    Dear community,
    I hope you can provide a simple resolution to my problem.
    I've created a workbook in Excel 2019 work - 1-sheet for raw dataset + second sheet with pivot table and slicers (simple - no VBA). This works well.
    I've sent it to my work computer which runs Excel 2010, but the slicers won't work.

    I'm unsure how to fix this.
    Can anyone advise?

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    05-19-2019
    Location
    Sunderland
    MS-Off Ver
    2007
    Posts
    5

    Smile Re: Excel 2019 workbook with slicer won't work in Excel 2010 - help please

    Workbook example attached
    Attached Files Attached Files

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,906

    Re: Excel 2019 workbook with slicer won't work in Excel 2010 - help please

    Data model engine changed between 2010, 2013 & 2016 and is not backward compatible if made using later versions.

    There's no workaround and compatibility is one directional. As well there are several issues updating models created older engine to later versions as well.

    It's especially complicated for Excel 2010, as there are 2 major versions for 2010 and it's not compatible with each other.

    Have a read of...
    https://support.office.com/en-us/art...6-a9402653cbf3

    And...
    https://www.sqlbi.com/blog/marco/201...ross-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
    05-19-2019
    Location
    Sunderland
    MS-Off Ver
    2007
    Posts
    5

    Re: Excel 2019 workbook with slicer won't work in Excel 2010 - help please

    Thanks for the advice.
    It looks like I won't be able to use my workbook at work, as I doubt they'll be upgrading Excel 2010 any time soon.


    Best wishes

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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