+ Reply to Thread
Results 1 to 10 of 10

Slicer Error VBA~~

  1. 06-24-2015, 11:57 PM #1
    meus
    meus is offline
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Slicer Error VBA~~

    Hi friends!!
    My excel frequently crashses and hangs and then shuts down automatically when i run a macro.. i am fed up of this...
    Can any ne help me what can be the cause..

    Capture.PNG
    Reply With QuoteRegister To Reply
  2. 06-25-2015, 12:10 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Slicer Error VBA~~

    Can you attach your excel that is crashing?
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 06-25-2015, 12:12 AM #3
    meus
    meus is offline
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Slicer Error VBA~~

    It is a large file and i have Very confidential datas... It will take one day to make a sample may be...
    Reply With QuoteRegister To Reply
  4. 06-25-2015, 12:31 AM #4
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Slicer Error VBA~~

    Without seeing anything, its difficult to figure out what is going wrong..
    Reply With QuoteRegister To Reply
  5. 06-25-2015, 12:55 AM #5
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Slicer Error VBA~~

    Or

    Atleat share the error line of code by clicking Debug button.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  6. 07-16-2015, 01:49 AM #6
    meus
    meus is offline
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Slicer Error VBA~~

    Still have this problem..
    Works perfectly fine on mine computer but anyhow it shows error on different computer...
    And on excel 10, the above error comes (Attached)
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  7. 07-16-2015, 03:22 AM #7
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Slicer Error VBA~~

    The Chart.Fullseriescollection was introduced with Excel 2013
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  8. 07-16-2015, 06:02 AM #8
    meus
    meus is offline
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Slicer Error VBA~~

    Thanks... but Even if i run in my friends computer having excel 2013, it frequently shows me "Method selected of object 'Slicer Item' failed" and stops on that debugging line.. When i try to debug and click DEBUG on that dialogue box, it crashes and excel hangs up and closes automatically...
    Any help would be appreciated..
    Reply With QuoteRegister To Reply
  9. 07-16-2015, 06:07 AM #9
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Slicer Error VBA~~

    If possible, attach the workbook (Without any confidential info)..

    Posters having Excel 2013 can test and see what is exactly wrong..
    Reply With QuoteRegister To Reply
  10. 07-16-2015, 12:53 PM #10
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Slicer Error VBA~~

    Or at least post the slicer code that fails.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make one slicer mirror filters of another slicer
    By IbenezPrez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2014, 02:00 PM
  2. Update Combox with Slicer items - getting error on Combox.listcount
    By Bigkx06 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2014, 02:47 PM
  3. how use slicer
    By Dadvar2 in forum Excel General
    Replies: 3
    Last Post: 09-05-2013, 08:29 AM
  4. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 AM
  5. [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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1