+ Reply to Thread
Results 1 to 3 of 3

page break issue

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    Pune
    MS-Off Ver
    Excel 2003
    Posts
    2

    page break issue

    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 header and footer. I have tried adjusting manually but I want some permanent solution and I guess there is some printer driver settings which affect pagebreaks.
    note: i ran the macro for the report on excel 2007, saved in 2003 format after running and then opened in excel 2003..

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: page break issue

    Hi

    page breaks heavily depend on the installed printer driver and the capacity of the printer installed. If your printer can do A3, but your friend's can't, you'll end up with significantly different numbers of pages.

    If your printer can print to 0.5 cm to the lower edge of the page, but your friend's can't, you'll end up with significantly different numbers of pages.

    Also, pages will break only between cells, so if you have cells with several lines of text, that will fit nicely on a page for one printer, the next computer may need to take double the amount of pages, because it just don't fit.

    Blank pages with just header and footer most probably have their cause in a manually set page break, assuming a print capability that the poor target printer can't produce, so the result is split between two pages.

    check your page layout, the respective printer capacity with regards to page margins and paper size and streamline to the common (i.e. smallest) denominator. (is that the correct term?). Be generous with margins. Give the data some leeway. Be prepared to sacrifice a couple of square inches of white space for the benefit of the report running OK on all kinds of printers.

    hth
    Last edited by teylyn; 11-24-2009 at 05:16 AM. Reason: typo .... late

  3. #3
    Registered User
    Join Date
    11-24-2009
    Location
    Pune
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: page break issue

    Hi thanks for your reply! really appreciate it. Is there some manual settings in windows that can be applied to the printer which might increase the automatic page breaks print area? because i checked both the machine and both have the same printer installed (network)...or is it an excel 2007 2003 issue...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1