Weird printing problem (Excel 97 on OS 95)

Topic

New Reply

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 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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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

Reply | Quote

Is there a custom format being applied to the cell?

Reply | Quote