Improper Page Breaks
 

I have created an excel report by running a macro on my machine. When i view
the report on my machine it displays the page breaks properly but when the
same report is opened on a friends computer it shows improper page breaks. It
takes 9 pages on my machine and 14 pages on my friends machine, out of these
14 pages some pages are blank with only the header and footer. I have tried
adjusting manually but I want some permanent solution.Also, I guess there is
some printer driver settings which affect pagebreaks. Please tell me how can
i solve this problem.

Improper Page Breaks
 

The Printer and Paper size determine the page breaks.

Mazhar wrote:

I have created an excel report by running a macro on my machine. When i view
the report on my machine it displays the page breaks properly but when the
same report is opened on a friends computer it shows improper page breaks. It
takes 9 pages on my machine and 14 pages on my friends machine, out of these
14 pages some pages are blank with only the header and footer. I have tried
adjusting manually but I want some permanent solution.Also, I guess there is
some printer driver settings which affect pagebreaks. Please tell me how can
i solve this problem.