I have a problem with an Excel report, in that the page breaks are set so
that each worksheet prints logically. However when the file is attached and
sent out internally, the recipients need to go in and re-format each
worksheet so that it prints out correctly.
Ideally the recipients would receive the file, highlight all the worksheets
and print out the 30-odd pages, rather than 100-odd pages of nonsensical
rubbish that Excel somehow decides is the correct way the pagebreaks are
positioned.
Thanks.

I think that the recipients have different printers (or different printer
drivers) than you.

If I were you, I'd be more conservative when applying those page breaks. Try to
make the pages fit on the worst printer you've seen. Margins will be larger
than you need. There'll be few lines per page as a result.

munozl wrote:

I have a problem with an Excel report, in that the page breaks are set so
that each worksheet prints logically. However when the file is attached and
sent out internally, the recipients need to go in and re-format each
worksheet so that it prints out correctly.
Ideally the recipients would receive the file, highlight all the worksheets
and print out the 30-odd pages, rather than 100-odd pages of nonsensical
rubbish that Excel somehow decides is the correct way the pagebreaks are
positioned.
Thanks.

--

Dave Peterson