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

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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!
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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
 
Upvote 0
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
 
Upvote 0
Hi there
I have also had similar problems when the printer does not have enough onboard memory.
regards
Derek
 
Upvote 0

Forum statistics

Threads
1,218,945
Messages
6,145,372
Members
450,612
Latest member
OVSD_DS

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top