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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Tom CieslikIT EngineerCommented:
Make sure all this settings are the same

Capture.JPG
Capture.JPG
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Printers and Scanners

From novice to tech pro — start learning today.