• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Slicer Problem

A

AdeleS

New Member
Hi, I want to export a PDF report with slicers to individuals outside the organization. My issue is I don't want the other values in a particular slicer displayed on the report. For instance if I have two customers ABC and BDE and I select BDE, the ABC value still displays (as non-selected but you can see it).

I tried changing the non-selected items to be white text and white fill so they "disappear" but that doesn't work because you need to be able to select multiple companies and as soon as you click on one value the rest of them disappear.

Any thoughts?!
thanks
 
Can you adjust the position of the slicer and/or the print range area, so that the Slicer doesn't get included in the PDF?
 
Thanks, good thought but won't really work in this case. To get the slicer outside of the print range it needs to be too far away from the other slicers and it looks wrong. Also, I've got some other users who aren't Excel experts and I can't make the solution too complicated (make selections, move slicer, reset print area, etc.)
 
Not sure why I didn't think of this before...
Right-click on the Slicer, select "Size and Properties". Select Properties tab, and then uncheck "Print Object". Now it won't print when you make the PDF! :rolleyes:
 
You must log in or register to reply here.
Back
Top