Hi,
just a quick help for someone that has no clue about where to start in VBA.
I want to change the slicer with respect to what is written in cell A3. I'd appreciate very much your help.
Vasco
Hi,
just a quick help for someone that has no clue about where to start in VBA.
I want to change the slicer with respect to what is written in cell A3. I'd appreciate very much your help.
Vasco
No doubt better methods - not something I'm familiar with I confess...
the above would be stored in Sheet1 within VBEPlease Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi,
the code worked beautifully on that workbook. Unfortunately for some reason I'm working in a different workbook (that is 23MB large) and the code doesn't work there.
I am getting an error in this line:
With ActiveWorkbook.SlicerCaches("Slicer_country")
I see 2 reasons for this to happen:
- I have another slicer on the same sheet
- The slicer is connected to data from different sheets
Any idea on how to fix this?
To be honest I have no real experience using Slicers.
From a Slicer Pivot perspective I would have assumed that for two pivots to share a Slicer they must be sourced from the same Pivot Cache - you imply this not to be the case.
In your real file is the Slicer cache named Slicer_Country ? [ie slicer is called Country]
Hi,
thanks for helping out. So, the slicer is called Country (therefore Slicer_Country). Can this bedifferent from the slicer cache?
Vasco
As mentioned I can't replicate the issue you're having and I can't create a Pivot Slicer from two different data sources [but again I know very little about them]
It might be an idea to post a sample that illustrates the error "in action"
Gostam
Please take some time to read forum rules - Especially concerning hijacking and mod requests
Gostam
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
If you break the Forum Rules one more time then you will not be allowed to use the Forum
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I know nothing about VBA, but this is exactly what I need to do. I tried copying and pasting the VBA code that DonkeyOte posted into the visual basic in my Excel spreadsheet, but it didn't work. is there something missing from the VBA code that is preventing it from working properly?
Welcome to the Forum, hankbon, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
You must have seen the posts above where some one else had been admonished previously but you did it anyway!
Last edited by protonLeah; 06-22-2012 at 11:48 PM.
Ben Van Johnson
Dear
Can anyone help me on How to i connect my Dropdown with Slicer in the sheet.
My Dropdown is in "AB2"
Slicer is for the Sales Personwise.
I need when i change my Drop down list to someone, All the data to be change as per that to my slicer as my slicer is connected to Pivot table
Anyone can help would be great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks