+ Reply to Thread
Results 1 to 3 of 3

VBA & PowerPivot: Selecting more than one selection from filter.

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    VBA & PowerPivot: Selecting more than one selection from filter.

    Hello friends, hope all is well! Help! =)

    OK, I have a PowerPivot and ran a code, and got the error: run time error 1004 the item could not be found in the olap cube.

    Trying to choose multi choices from the filter in the PowerPivot table.

    A. Here is the code; please guide me and help me fix the code:

    B. Or better yet, can I have the selection picked up from a range A2:A100 from sheet2?


    Please Login or Register  to view this content.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: VBA & PowerPivot: Selecting more than one selection from filter.

    Looking at the format of the rest of them, I suspect this:

    Please Login or Register  to view this content.
    should read:

    Please Login or Register  to view this content.
    Rory

  3. #3
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    Re: VBA & PowerPivot: Selecting more than one selection from filter.

    I am sorry but I think I found the issue!

    some of the values that I am placing in the code don't exist in the pivot table. That is why the error occurs.

    Thank you very much!
    Last edited by saudi_red_neck; 12-05-2018 at 01:26 PM.

+ 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. [SOLVED] PowerPivot CALCULATE ignoring filter?
    By TitansGo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2016, 04:09 PM
  2. Why do you use Filter(ALL) in time calc in powerpivot
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 07-13-2016, 03:28 PM
  3. [SOLVED] Filter WITHIN Powerpivot table
    By stephme55 in forum Excel General
    Replies: 2
    Last Post: 07-11-2016, 12:48 PM
  4. PowerPivot Help: Organizing Data using a Filter
    By chrischunggg in forum Excel General
    Replies: 3
    Last Post: 06-13-2016, 09:02 AM
  5. Filter doesn't work after refresh PowerPivot Data Model
    By bluesky63 in forum Excel General
    Replies: 0
    Last Post: 05-26-2015, 10:43 PM
  6. Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  7. VBA to change filter for n pivots based on page filter selection for the first pivot
    By shama.arige in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2011, 11:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1