Link to home
Create AccountLog in
Avatar of manch03
manch03

asked on

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?
Avatar of Tom Cieslik
Tom Cieslik
Flag of United States of America image

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.
Avatar of manch03
manch03

ASKER

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?
Make sure all this settings are the same

User generated image
User generated image
Is that label printer the user's default printer? If it is, make the standard printer the default and see what happens.
Avatar of manch03

ASKER

The default printer is the same as all other users - same settings - I am stumped as to why this file will not print correctly.
Avatar of manch03

ASKER

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
Avatar of manch03

ASKER

There are no Output options (match page size) on any of the printer settings.
Avatar of manch03

ASKER

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.
What model printer is this? Somewhere you have to be able to tell its paper size.
Avatar of manch03

ASKER

By default it is set to 8.5 x 11. It’s a brother multi function 8950.
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.
ASKER CERTIFIED SOLUTION
Avatar of Tom Cieslik
Tom Cieslik
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of manch03

ASKER

Thank  you Tom for the second pair of eyes.
You are very welcome :)
Excel cell sizes: that's exactly what I said in my last comment...
Avatar of manch03

ASKER

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?
Avatar of manch03

ASKER

Never mind - the cells are locked..