http://blogs.office.com/b/microsoft-excel/archive/2011/01/27/slicers-and-vba.aspxToday&rsquo;s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA. For more information about slicers, read PivotTable Slicers on Jan Karel&rsquo;sen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2011/01/27/slicers-and-vba.aspx#24952Tue, 22 Mar 2011 20:51:10 GMT53587256-c606-4c9b-bad4-97c86b12ce62:24952AndyMay<p>Hi Jan</p> <p>I messed about with this code, and tried to use it to change a slicer that I have created on a pivot that is using a Cube a a source, I wanted to set up the slicer so that users wouldn&#39;t have to change it for a value that changes every time the cube builds. </p> <p>the problem is that it won&#39;t let me change the selected property of items in the slicer, I just get an error 1004 &nbsp;&#39;Application-defined or Object-defined error&#39;</p> <p>I guess this means that we can&#39;t change these values for pivots that are created out of extenal data, which from my point of view makes the whole thing useless!</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=24952" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2011/01/27/slicers-and-vba.aspx#24347Sat, 19 Feb 2011 23:26:43 GMT53587256-c606-4c9b-bad4-97c86b12ce62:24347melonakos<p>Hi Diego, &nbsp;I ran across the work you guys have been doing connecting Excel to Windows HPC. &nbsp;We&#39;re looking to connect with you about GPU-accelerating Excel, via our new product libJacket (<a rel="nofollow" target="_new" href="http://www.accelereyes.com">http://www.accelereyes.com</a>). &nbsp;Would be great to chat with you by phone if possible. &nbsp;Email me at john.melonakos@accelereyes.com. &nbsp;Thanks!</p> <p>-John</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=24347" width="1" height="1">