From: Nadine on 1 Jun 2010 17:08
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.
Prev: MATCH returning #N/A
Next: how can we make one constant number to be act as variable