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?
Printers and ScannersMicrosoft OfficeNetworking

Avatar of undefined
Last Comment
manch03

8/22/2022 - Mon
Tom Cieslik

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.
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?
Tom Cieslik

Make sure all this settings are the same

Capture.JPG
Capture.JPG
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
hdhondt

Is that label printer the user's default printer? If it is, make the standard printer the default and see what happens.
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.
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
manch03

ASKER
There are no Output options (match page size) on any of the printer settings.
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.
hdhondt

What model printer is this? Somewhere you have to be able to tell its paper size.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
manch03

ASKER
By default it is set to 8.5 x 11. It’s a brother multi function 8950.
hdhondt

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
Tom Cieslik

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
manch03

ASKER
Thank  you Tom for the second pair of eyes.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Tom Cieslik

You are very welcome :)
hdhondt

Excel cell sizes: that's exactly what I said in my last comment...
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?
Your help has saved me hundreds of hours of internet surfing.
fblack61
manch03

ASKER
Never mind - the cells are locked..