locked
Printing from Pivot table with slicers RRS feed

  • Question

  • I am using excel 2010 and creating pivot table from Power Pivot.  I created a pivot table with department slicers.  All is good, the problem I am having is whilst in an unfiltered position (ALL) of the slicers

    (departments) I get 200 pages, now when I  click on a given department with say 10 pages, I still get the same 200 pages with the first 10 pages showing the data from the clicked department and 190 blank pages.

    All I want is to get a WYSIWYG (What you see is what you get) of what is on the screen as my print, but I am getting extra blank pages right after the data.  How do I resolve this.

    Below are the steps I go thru to print 

    1. Select slicers in unfiltered position (ALL)

    2. Select entire pivot table

    3. Select Page layout  and select print area.

    4.  Save

    5. Click on Print Preview to preview the print

    6. Click on a given department in the slicer and repeat item 5, but this gives me blank pages after the data.

    Do I need any other step?  Can someone please help me?


    Kofi





    • Edited by kdankwah Monday, April 13, 2015 6:30 PM
    Monday, April 13, 2015 2:11 PM

Answers

  • Yes, I just found out that you can use count function on the print area.  I saw this on this youtube, so if anyone is interested, here is the link:

    https://www.youtube.com/watch?v=YJs60En3vBs

    Its know as the dynamic print range.

    Thanks


    Kofi



    • Marked as answer by kdankwah Friday, May 1, 2015 8:59 PM
    • Edited by kdankwah Friday, May 1, 2015 9:01 PM
    Friday, May 1, 2015 8:59 PM

All replies

  • Kofi, are you still trying to get this figured out?

    Thanks!


    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Friday, May 1, 2015 8:43 PM
  • Yes, I just found out that you can use count function on the print area.  I saw this on this youtube, so if anyone is interested, here is the link:

    https://www.youtube.com/watch?v=YJs60En3vBs

    Its know as the dynamic print range.

    Thanks


    Kofi



    • Marked as answer by kdankwah Friday, May 1, 2015 8:59 PM
    • Edited by kdankwah Friday, May 1, 2015 9:01 PM
    Friday, May 1, 2015 8:59 PM