+ Reply to Thread
Results 1 to 2 of 2

slicer crash excel only on some laptops

  1. #1
    Registered User
    Join Date
    10-22-2017
    Location
    ENGLAND
    MS-Off Ver
    2016
    Posts
    35

    slicer crash excel only on some laptops

    Not sure exactly where to post this, however my excel program contains a lot of VBA code.
    There is a slicer on one worksheet that takes info from a table - no vba code involved in the slicer or the table.
    On my desktop PC and another desktop PC it works like a dream, however on a couple of Laptops when the user selects in the slicer, it puts up the circle loading message, then a few second after, it closes down the entire excel (any open workbooks), and re-starts excel. (no error messages or "do you want to save?" messages).

    Everyone is using windows 10 and excel 2016.
    the table consists of about 20 columns but only 50 rows.
    the slicer only sorts three criteria.
    Have tried the following with no sucess:
    disabling graphics accelleration,
    putting slicer on same worksheet,
    put workbook file on hard drive of laptop (instead of over network)

    I want the program to work on all versions of excel 2016 and any laptop/PC, but I don't want it to crash disastrously on certain laptops!
    Is it better to give up with the slicer (a shame), or is there something I can do to work around or fix the issue.
    Please help, thank you.

  2. #2
    Registered User
    Join Date
    10-22-2017
    Location
    ENGLAND
    MS-Off Ver
    2016
    Posts
    35

    Re: slicer crash excel only on some laptops

    I have removed the slicer and made a code that replicates it - no crashes now. I agree that this is only a workaround and not a solution.

+ 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: 9
    Last Post: 01-09-2019, 12:33 PM
  2. Macro will not run on other laptops
    By chrisklti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2018, 07:16 AM
  3. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  4. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  5. [SOLVED] Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = CRASH
    By Alex Piotto in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-27-2018, 07:53 AM
  6. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  7. Excel and Laptops
    By astrikor in forum Excel General
    Replies: 3
    Last Post: 02-12-2006, 07:29 PM

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