Excel 2010 pivot table - printing problem

I have problem with a pivot table - I have page breaks set up but can't seem to get the bottom line of the grid to print without turning on the "print gridlines" option on the page layout section.
I do not want the additional grid columns to appear - in my example it creates two more columns where there is no data...

I have attached the document.  I want a horizontal line to appear at the bottom of each section.
Who is Participating?
klitton7Connect With a Mentor Author Commented:
Received no response to this issue - I will close it.
Rob HensonFinance AnalystCommented:
The additional two columns is to allow for the header in A1 extending across to column E.

Which version of Excel are you using, I see you have saved as an xls rather than xlsx which has been in use since Excel 2007.

Simple change of format on the Pivot and you get the Total rows with line formatting which will then show on the Print. I went into Options and on the Display ticked the option for Classic Display.

See attached.

BTW, I have reduced the file size (considerably) by removing the surplus rows and formatting on the HR Data tab. You have data down to row 6000+ but the Used area was down to 59000+.

I am surprised I din't see this question while it was live.
klitton7Author Commented:
Thanks for your response.  I resaved the document using Excel 2010 and also PDF.
I want the same "look" I currently have but as you can see for every page break the bottom line is not visible nor does it print.
Is there a fix for this?  I had already reviewed the formatting options that you had recommended, but didn't see any that suited our needs.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.