Hi all
I'm at my wit's end with this, can anyone help?
I have manually set page breaks on a spreadsheet, and also have print titles set, all of which work fine. However when the user filters a column and then tries to print just the filtered lines (which are all consecutive), it prints pages with just the heading for every page the filter has excluded. If they filter to something that would have been on page 3 on the whole document, they get it, plus 2 pages of headings.
Another forum suggested removing the print area, which I've done, but this hasn't solved my problem, which I have in both versions 2007 and 2000.
Any help much appreciated!
Regards,
Su
<!-- / message -->
I'm at my wit's end with this, can anyone help?
I have manually set page breaks on a spreadsheet, and also have print titles set, all of which work fine. However when the user filters a column and then tries to print just the filtered lines (which are all consecutive), it prints pages with just the heading for every page the filter has excluded. If they filter to something that would have been on page 3 on the whole document, they get it, plus 2 pages of headings.
Another forum suggested removing the print area, which I've done, but this hasn't solved my problem, which I have in both versions 2007 and 2000.
Any help much appreciated!
Regards,
Su
<!-- / message -->
<!-- controls -->
