Please help--spreadsheet prints ok at home, but not at work.

[imported_unknown]

Hello,

I recently completed a project for a former employer. They are paying me as a consultant. I wrote the VBA program at home on my PC and brought it in and installed it for them.

All the program does is take a 4-column, 14,000-row list and wraps it around on the spreadsheet, much like the way a newspaper column is formatted. I have everything sized so that three sections (12 columns total) fit on each page. After every 234 items, it starts a new page. I have added some formatting (borders, colored cells, etc.). When I print at home, the pages look as they should. However, my former employer told me that after they ran the program and tried to print, some of the formatting was gone and the headings were missing.

Does anyone know what's wrong? They said that when they print-preview, everything looks as it should. It's only when they actually print that the pages don't look right.

Thanks for everyone's help!

 

[plettieri]

I am not sure if this is the same issue, as i have difficulty on printing excel when i change printers at work.
Are you using the same kind printers in both places? Some set up features may be different...

hope this helps...

pll

 

[NateO]

Some set up features may be different...

To say the least! And a good pointer. If Excel's still previewing the data appropriately, there could easily be a driver or hardware issue.

Something I ran into, which is a little different, is that an individual I worked with was forced to print to certain hi-end printer via a forced address. Meanwhile, they had a list of eight different printers, they had the wrong printer set up as their default printer. It shot the print-out to the correct printer, but using the wrong driver, resulting in some nasty dpi print-outs.

Food for thought, not a definitive answer... Might want to make sure that the driver's correct and that it's maxed out.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-10-02 20:32

 

[Derek]

Hi there
I have also had similar problems when the printer does not have enough onboard memory.
regards
Derek