Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-08-2012
Member
 
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?

Reply With Quote
  #2  
Old 06-08-2012
Member
 
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.
Reply With Quote
  #3  
Old 06-08-2012
Member
 
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...
Attached Files
File Type: doc Excel 2010 Printing PivotTables.doc (232.0 KB, 3 views)
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "MS Office Excel 2010: Unable to print PivotTables with non-PivotTable data at bottom of table."
Thread Thread Starter Forum Replies Last Post
unable to print borders and gridlines in Excel 2010 Mayuus Windows Software 5 05-12-2011 08:01 AM
Unable to open a Sample Excel file using Office 2010 Caelaan Windows Software 5 10-03-2010 04:14 PM
Unable to print in Office 2010 Smita.bendal Windows Software 4 27-02-2010 01:53 PM
How to share MS Access data with MS Excel in Office 2010? Adrina_g Windows Software 5 29-01-2010 05:08 PM
A Data Table in Microsoft Office Excel kattman Guides & Tutorials 7 29-04-2009 06:58 PM


All times are GMT +5.5. The time now is 07:51 AM.