Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Problems (Excel2002)

    I have been sent a spreadsheet from a '97 user. it prints perfectly when I allow it to go across two pages.

    When I try to restrict it to print on 1 page wide it prints each cell on a separate page. If I go into page brak preview each cell is surrounded in blue. If I try to drag the blue lines to increase page size it tells me my margins sizes are the problem. If I return to page set up it wont let me select the magins tab.

    If I go to the margins tab before I set a 1 page wide instruction they are perfectly standard settings!

    The spreadsheet has hidden columns and a group. I have tried removing these to no avail. I have tried cutting and pasting data to a new workbook but ths does not get rid of the problem.

    Unfortunately the data is sensitive so I cannot post the workbook for anyone to look at - I just wondered if anyone else has experienced anything similar - or anyone has any bright ideas!

    Thanks

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Problems (Excel2002)

    Have had a similar sounding problem on more than one ocassion. The fix - crazy as it sounds - was to

    1. Select another printer (hopefully this is possible for you)
    2. Print a single page to this second printer (in one case I actually only had to view it in PrintPreview)
    3. Select the original printer...

    ...and what do you know the problem has disappeared. Never have figured out why this works, but it does.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Problems (Excel2002)

    I've had this happen to me too and it just drove me crazy until I figured out how to fix it.

    Another way (which is similar to the above fix) is to remove your printer and then re-install it.

    Yes, it's a crazy way to fix it, but it works every time.

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Printing Problems (Excel2002)

    Must slow down printing tho' <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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