View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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.