+ 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
    365
    Posts
    8

    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
    365
    Posts
    8

    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
    Office 365 ProPlus
    Posts
    5,855

    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
    365
    Posts
    8

    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)

Similar Threads

  1. Replies: 0
    Last Post: 09-27-2019, 03:34 PM
  2. macro works in excel 2019 but not in 2010 this gives type mismatch error 13
    By Newbikonob1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2019, 06:25 AM
  3. VBA switches sheets running in excel 2019 v 2010+2007+2011 for MAC, where it does not
    By Ramses505 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2019, 11:44 AM
  4. Excel 2010 vs. Excel 2016 Slicer
    By mycon73 in forum Excel General
    Replies: 0
    Last Post: 03-18-2016, 12:40 AM
  5. [SOLVED] Excel 2010 workbook macros do not work in 2013
    By voorhees404 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2015, 01:02 PM
  6. [SOLVED] Workbook does not work in excel 2007, but is fine in 2010
    By cath1509 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 02:59 PM
  7. Replies: 0
    Last Post: 09-18-2012, 11:24 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