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

Reply
 
Thread Tools Search this Thread
  #1  
Old 16-04-2011
Member
 
Join Date: Feb 2011
Posts: 68
Error message given by excel 2007 while trying to print

I have a book where I get the error "Print titles must be contiguous and complete rows or columns." trying to get a print preview or print. Everywhere I looked said it is a problem with print titles, but I have none. Also I have no heading or footer. The only way to allow printing is entering the print window titles, and then clicks OK to go back. I tried to copy the worksheets to a new book, but the problem persists. My book contains a large number of spreadsheets, so manually entering the print titles and endorsement is not a viable solution
Reply With Quote
  #2  
Old 16-04-2011
Member
 
Join Date: Jan 2008
Posts: 3,384
Re: Error message given by excel 2007 while trying to print

It seems like you have incomplete row / column address to the impression created. Click File on the menu and select Page Setup. In the dialog box settings page, click the sheet tab and clear or correct the addresses indicated in the rows to repeat at top or Columns to repeat at left. Be sure to select on the row number of the row that contains the contents to print. If more than one row must be consecutive (1, 2, not 3 to 1 and 3) It also can help to drag or click to select multiple rows -. Be sure not to use the Ctrl key.
Reply With Quote
  #3  
Old 16-04-2011
Member
 
Join Date: Feb 2011
Posts: 123
Re: Error message given by excel 2007 while trying to print

This is almost an exact copy paste all the other "answer" is available online. None of the above applies to my book. There are absolutely no rows or columns set to repeat: not present in the boxes. No print area "set." The only solution I've found to work is going to set the window page of each of my individual worksheets and click Preview. This will load it can then do a print command. I was lucky that this book contained only a dozen spreadsheets, but how I can ensure that this will not happen in some of my largest book when all causes reported that the issue is not really in the book IT?
Reply With Quote
  #4  
Old 16-04-2011
Member
 
Join Date: Apr 2008
Posts: 3,260
Re: Error message given by excel 2007 while trying to print

I would like to suggest you to update your driver and so that you can solve your issue. I think you got this error due to this mistake and so therefore I would like to suggest you to download the latest driver and then install it on your system. To do this go to some official website and make search for your desired driver and after that save it on your system. Once you complete this install in your system and after that go through your issue.
Reply With Quote
  #5  
Old 16-04-2011
Member
 
Join Date: May 2008
Posts: 4,339
Re: Error message given by excel 2007 while trying to print

I would like to suggest you the following steps and so that you can solve your issue. To do this goes through the following steps and after that your issue will get solved. To do these follow the steps below: First choose the page layout and after that make click on the print title and after that make clear the all Print Area so that it is Blank. Now once you complete this try to go through your issue and I hope this will really help you.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Error message given by excel 2007 while trying to print"
Thread Thread Starter Forum Replies Last Post
How to fix Print Error Message in Microsoft Excel The-Farmer MS Office Support 3 13-01-2012 04:58 PM
?The language DLL VBE6intl.dll could not be found? error message in Microsoft Excel 2007 pREMAsAGAR Windows Software 6 14-05-2011 11:06 AM
Getting Error message while creating Pivot table in Excel 2007: ?data source reference is not valid? Man-Than Windows Software 5 14-05-2011 10:49 AM
MS Excel 2007: Display error message that ?The Picture is too Large and will be truncated? Strangers Windows Software 3 26-11-2010 06:13 AM
Error Message while trying to Save a file in Excel 2007 hatred Windows Software 5 26-03-2010 04:00 AM


All times are GMT +5.5. The time now is 05:11 AM.