Error created when try to Print Preview or Print

N

Nadine

When try to print or print preview system is generating an error:
"Print titles must be contiguous and complete rows or columns."

Used excel for years ever seen this error before.

Using Excel 2007 on Vista, we just upgraded to SP2 for both systems.

After testing a few times, I notice that system is generating a Name Range
with no referencing cell range, the name range is called Print_Titles.
If I delete the name range it removes the error message and able to use
print preview and able to print.

Notice it is occurring more ofter when client is copying a worksheet to
another workbook yet the original work book didn't have a name range
Print_Titles to begin with, yet after the copy now both workbooks have the
unreferenced named range.

Is this a know issue? Is something generating this in error.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top