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