Error Code when trying to print an excel sheet.

Hello everyone,

we have an employee who has a problem printing an excel sheet, it gives the following error: "Print titles must be contiguous and complete rows or columns" the employee is using Excel 2003, but i don't have it I use Excel 2007 and I can view it, but i get the same error when printing. any help would be greatly appreciated.

Thanks,
LVL 1
raphabarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ScottMorrisCommented:
Under "File > Page Setup" (in Excel 2003, although you can probably find the same screen via different buttons in Excel 2007), check the "Sheet" tab.  Can you post what is listed under both "Rows to repeat at top" and "Columns to repeat at left"?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
raphabarAuthor Commented:
Hello Scott,

thanks for the feedback, I checked the "rows to repeat at top" and it shows the following: $1:$1

the "Columns to repeat at left" is blank, no entries in there.
0
Rory ArchibaldCommented:
Are you printing one sheet or the whole workbook? If the latter, you need to check the setup for each sheet.
0
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

raphabarAuthor Commented:
Yes, i am printing one sheet.
0
Rory ArchibaldCommented:
Do you have any merged cells on the first row? Or any code in the workbook?
0
raphabarAuthor Commented:
I do have some formulas starting line two,and on cell G. No merged cells as far as I could tell.

Also,
I need to make a correction the problem description, the employee is actually using Excel 07 not 03 as I stated earlier. Thanks!
0
raphabarAuthor Commented:
Hello,

I actually got it working and here is what I did:

Go to formula tab - select name manager.  Delete anything called Print_Titles.

after that I tried to print and it printed fine, I am not sure why, but it works.

thanks all for the suggestions.


0
raphabarAuthor Commented:
The answer was not accurate but at least it directed me to the right direction
0
rameshabsCommented:
I got the same problem. user is using MS office 2007 one particular excel file giving same error as mentioned above. I have save that particular file in excel 2003 format. I was able to print entire excel sheet  without any issues. I hope it will works.....please try and let me know....
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.