Microsoft Office 2007 Excel spreadsheet not printing correctly for other users.

I have a file with data that prints labels in Microsoft Office 2007 Excel.  I have the file stored on a shared network drive and when other users try to print the file, the labels are way off.  The file will only print correctly on my workstation.  All the printer settings are the same (we checked) and we are all printing to the same printer.  Other users want to use the spreadsheet and make their own changes, but the file will not print correctly.  Any ideas?
manch03Asked:
Who is Participating?
 
Tom CieslikIT EngineerCommented:
After Live session with manch03, I've realized that row high on other computers was different.
That's why there was 2 row more on print on second computer compared to first one.
We've corrected row high and print preview was the same.
0
 
Tom CieslikIT EngineerCommented:
Compare Printing Preferences on your workstation and other affected computer.
For me it looks like Paper size and setting for Output size are different

Also make sure you have no installed any special paper from other printing software like label pro and other users doesn't have this software installed.
0
 
manch03Author Commented:
We checked the printer settings - the paper size and output size are the same.  There is no special paper but there is one user with a label printing software on her workstation, but not the other.  All workstations are using Microsoft Office 2007 and Windows OS 7 Professional. I will find out the label software on the one workstation that is not working.  How would that impact an Excel spreadsheet when printing to an entirely differently printer?
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
Tom CieslikIT EngineerCommented:
Make sure all this settings are the same

Capture.JPG
Capture.JPG
0
 
hdhondtCommented:
Is that label printer the user's default printer? If it is, make the standard printer the default and see what happens.
0
 
manch03Author Commented:
The default printer is the same as all other users - same settings - I am stumped as to why this file will not print correctly.
0
 
manch03Author Commented:
Can I attach a file to show you what it looks like when printed from the workstations that are not printing correctly?  I will try to paste a screen shot -
Label-Print-12.20.2017.pdf
0
 
manch03Author Commented:
There are no Output options (match page size) on any of the printer settings.
0
 
manch03Author Commented:
From user that cannot get the labels to print - " the top row starts printing a bit too high, and by the time it get to the bottom rows, this is how the labels look."  - that was the file I sent.
0
 
hdhondtCommented:
What model printer is this? Somewhere you have to be able to tell its paper size.
0
 
manch03Author Commented:
By default it is set to 8.5 x 11. It’s a brother multi function 8950.
0
 
hdhondtCommented:
So, are you printing a whole sheet of labels?

Excel is not exactly the best app to print labels with. With Excel you need to specify the cell sizes so the text falls exactly in the labels. Any small error will accumulate as you go down the page.

A much better way would be to use Word's label printing. You can import the date from Excel, and you can specify precisely what type labels you are using. You can either select the manufacturer & model, or create your own label, giving margins, spacing, etc.
0
 
manch03Author Commented:
Thank  you Tom for the second pair of eyes.
0
 
Tom CieslikIT EngineerCommented:
You are very welcome :)
0
 
hdhondtCommented:
Excel cell sizes: that's exactly what I said in my last comment...
0
 
manch03Author Commented:
Now I have another issue:  The second user cannot change the row height - I have tried saving the doc as a different name, changing the row height and it will not stick.   I save the change and check the row height and it remains the wrong size.  I tried applying to all cells...  do you think ther eis a lock on the cells?
0
 
manch03Author Commented:
Never mind - the cells are locked..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.