Excel file printing issue
Solved/Closed
dimahappy
Posted messages
97
Status
Membre
-
ME -
ME -
Hello,
when I preview or launch the print of an Excel file, a message appears indicating that "the print titles must be adjacent and consist of entire rows or columns."
first, what is this problem and what should I do as a solution?
well, I am using Office 2007 as my office software.
Thank you for getting back to me.
when I preview or launch the print of an Excel file, a message appears indicating that "the print titles must be adjacent and consist of entire rows or columns."
first, what is this problem and what should I do as a solution?
well, I am using Office 2007 as my office software.
Thank you for getting back to me.
Configuration: Windows XP Firefox 3.0.7
7 réponses
I had the same problem with a sheet from a 2003 workbook that had a print title range, moved to a 2007 workbook.
During the move, the row reference "2003" ($1:$8) was converted to a truncated range of 256 columns ($a$1:$IV$8), which caused the error later reported by 2007.
Going to page layout, changing something (or nothing!) and validating does indeed resolve the problem because it effectively removes the truncated print title definition limited to the number of columns supported by 2003..
pjv
During the move, the row reference "2003" ($1:$8) was converted to a truncated range of 256 columns ($a$1:$IV$8), which caused the error later reported by 2007.
Going to page layout, changing something (or nothing!) and validating does indeed resolve the problem because it effectively removes the truncated print title definition limited to the number of columns supported by 2003..
pjv
... but you have to make it do so...
Thank you for the tip.