Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weird printing problem (Excel 97 on OS 95)

    I'm coming to my knowledgeable friends at Woodys since I've received a user-question that I can't figure out! We have a company-wide excel file accessable off our company intranet. (I have attached just a snapshot of the area of the sheet I will be talking about). Users usually will choose from the list of three Payment Type options on the right hand side, and it will automatically fill in that selection (0,A or [img]/forums/images/smilies/cool.gif[/img] in the payment type blank on the left.
    This ONE user (doesn't affect anyone else) -- when she chooses A or B, everything is fine. She can see the A or B, and print the document with no problems. However, when she choose the 0 option, she can see if fill in the 0 on her screen, but when she prints, that payment type filed is blank.
    This has really stumped me! Is there something that tells Excel to not PRINT a zero value -- even though it is SHOWING it to her on the screen? I can't give you the whole Excel file as an attachment due to restrictions here -- that's why just the screenshot
    Thanks! Pribb
    Attached Images Attached Images

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weird printing problem (Excel 97 on OS 95)

    Is this user using a different printer than everyone else, or a different driver version? From the screen shot, it looks like the cells are just large enough to hold one character. If there is a bug in the driver, or a slight difference in the printer font, it might possibly result in this problem.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weird printing problem (Excel 97 on OS 95)

    I think they are all connected to the same network printer. She is at a different location than me, so I will have to call her and see if I can find which printer driver she is using.

  4. #4
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SAME Weird printing problem (Excel 97 on OS 95)

    We have checked drivers and printers. Still having this problem, and now have found a second user with the same issue. Any more ideas from anyone?

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SAME Weird printing problem (Excel 97 on OS 95)

    Is the printing being done using straight Excel File Print, or is there macro code involved?
    Legare Coleman

  6. #6
    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: SAME Weird printing problem (Excel 97 on OS 95)

    Is there a custom format being applied to the cell?
    [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
  •