Results 1 to 3 of 3

Thread: MS Office Excel 2010: Unable to print PivotTables with non-PivotTable data at bottom of table.

  1. #1
    Join Date
    Aug 2012
    Posts
    2

    question MS Office Excel 2010: Unable to print PivotTables with non-PivotTable data at bottom of table.

    First time posting here, so hello everyone.

    I've been using pivot tables successfully for five years now. I've gone from Excel 2003 to Excel 2007 and now Excel 2010 without any difficulties until now.

    In previous versions of Excel, I could print the pivot tables with an external (non-pivot table data) legend at the bottom of the pivot table producting some great reports. Now, with Excel 2010, only the first page prints, the footer information is merged in with the last couple of lines of the pivot table, and the non-pivot table data is completely ignored.

    I've attached an example. What am I missing here?

  2. #2
    Join Date
    Jan 2006
    Posts
    605

    Re: MS Office Excel 2010: Unable to print PivotTables with non-PivotTable data at bottom of table.

    Where is the example that you have attached? Anyways, can you try to right click in the column for the years, and selecting "Field Settings", the Field Settings dialog is displayed, which shows the custom name of "Year", but the custom name is not displayed in the PT.

  3. #3
    Join Date
    Aug 2012
    Posts
    2

    Re: MS Office Excel 2010: Unable to print PivotTables with non-PivotTable data at bottom of table.

    Sorry...had to convert .docx to .doc to attach. Here it is...

Similar Threads

  1. unable to print borders and gridlines in Excel 2010
    By Mayuus in forum Windows Software
    Replies: 5
    Last Post: 05-12-2011, 07:01 AM
  2. Unable to open a Sample Excel file using Office 2010
    By Caelaan in forum Windows Software
    Replies: 5
    Last Post: 10-03-2010, 03:14 PM
  3. Unable to print in Office 2010
    By Smita.bendal in forum Windows Software
    Replies: 4
    Last Post: 27-02-2010, 12:53 PM
  4. How to share MS Access data with MS Excel in Office 2010?
    By Adrina_g in forum Windows Software
    Replies: 5
    Last Post: 29-01-2010, 04:08 PM
  5. A Data Table in Microsoft Office Excel
    By kattman in forum Guides & Tutorials
    Replies: 7
    Last Post: 29-04-2009, 05:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •