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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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

Legend
Joined
Feb 17, 2002
Messages
9,700
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

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
Hi there
I have also had similar problems when the printer does not have enough onboard memory.
regards
Derek
 

Forum statistics

Threads
1,144,058
Messages
5,722,269
Members
422,419
Latest member
Havok390

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
Top