• 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.

Formatting and printing a pivot table

K

kateb64

New Member
I'm at my wits end with this one! I have a long, continuous pivot table. However, when I try to print it, it will print the first page (to the very bottom of the paper) and no more! Page break preview shows it as multiple pages but that's not how it prints out. As the length will vary according to the data it is pivoting I can't use manual breaks, and section breaks aren't applicable either as it's one long section. Any ideas?


Also, when I re-open this file and refresh the data it reformats the cell borders and makes some of them black lines but leaves others alone! I have checked the "Preserve cell formatting on update" and it preserves it when the file remains open (however many times I refresh the data) but not when it's closed and opened again.


By the way, I am using 2010 but the file will be used by people with anything from 1997 upwards so needs to be as simple as possible!
 
have you tried going to print preview, go Page set up, go "Page" tab and set the scaling to Fit to 1 page(s) wide by 1 tall? that should fix your mulitple pages problem, if that's your issue?
 
Thanks Fred, but the pivot could be anything from one page to 4 or 5! Maybe I have to look at a macro to reformat it each time, or find an alternative to the pivot.
 
Hi Kate ,


Is this problem only with this particular pivot table ?


What about other pivot tables ? Other worksheets ? Other documents , in Word for example ?


Narayan
 
Other worksheets and Word documents are fine - I don't have another pivot to test it on. However, I have sort of solved it by giving up on the pivot table and using a filter instead, with a macro doing the filtering etc. It's not ideal, but the best solution I can come up with. Thanks!
 
I would like to know if someone found a solution to be able to print more than the first page when such problem occurs. The only way I can have all the rows is when I force the format to adjust the worksheet on one page, but since I have a lot of datas it not possible to do so. Like kateb64 did, I will (for now) resolve myself to copy paste the datas to an other worksheet and print them from there, but I would really like to find out what's wrong with this pivot table.
 
You must log in or register to reply here.
Back
Top