FastEddieC
MIS
I apologize in advance for the length of this post.
Environment:
We are still in the process of switching from PCs with XP / Office 2003 to Win 7 / Office 2010. All of the PCs that had Office 2003 have been upgraded to 2010 but most of the shared documents on our file server are still in the 2003 format. Approx half of the OS’s are on Win 7 now.
Task:
We have about 10 users that enter data into a group of shared spreadsheets. These spreadsheets are printed and signed. Each tab/sheet has multiple pages, each page has a title at the top, signature lines at the bottom and the pages line up perfectly to print on individual single pages (and have worked that way perfectly for years).
Problem:
Recently three users are having problems with page margins, the other seven are fine. The problem is a print preview of page 1 shows 2 extra rows at the bottom – which is the page title from page 2. And with multiple pages in a workbook, and each one of those pages printing two extra rows,… by the time you get to page 20 - more than half of it’s info is on page 19. And another user is just the opposite, they can view the same document and come up 2 rows short.
The three with the problem have not had anything changed on their PC recently. Normally the first thing you look at for a problem like this is the printer/printer driver. While troubleshooting one of the PCs having this problem, I compared it to an identical PC that prints normal (same manufacturer, OS and version of Office). I made sure they both had:
[ul]
[li]Same Network Printer[/li]
[li]Same Document[/li]
[li]Same Margins[/li]
[li]Same Page Setup[/li]
[li]Same Excel Program Options[/li]
[/ul]
But still the one with the problem printed part of the next page’s title (two rows extra) at the bottom of the page. I even set them both up on Microsoft XPS Document Writer (as suggested on another site with similar prob) – no joy. I considered inserting page-breaks. It would work for one user (the one that has extra lines) but not the one who prints 2 rows short. More importantly, with 63 spreadsheets, 12 sheets each and some sheets with 20+ pages – it adds up to around 600 or so page-breaks I would have to add.
If you have read this far then I thank you. LOL Any help would be appreciated.
Eddie
Environment:
We are still in the process of switching from PCs with XP / Office 2003 to Win 7 / Office 2010. All of the PCs that had Office 2003 have been upgraded to 2010 but most of the shared documents on our file server are still in the 2003 format. Approx half of the OS’s are on Win 7 now.
Task:
We have about 10 users that enter data into a group of shared spreadsheets. These spreadsheets are printed and signed. Each tab/sheet has multiple pages, each page has a title at the top, signature lines at the bottom and the pages line up perfectly to print on individual single pages (and have worked that way perfectly for years).
Problem:
Recently three users are having problems with page margins, the other seven are fine. The problem is a print preview of page 1 shows 2 extra rows at the bottom – which is the page title from page 2. And with multiple pages in a workbook, and each one of those pages printing two extra rows,… by the time you get to page 20 - more than half of it’s info is on page 19. And another user is just the opposite, they can view the same document and come up 2 rows short.
The three with the problem have not had anything changed on their PC recently. Normally the first thing you look at for a problem like this is the printer/printer driver. While troubleshooting one of the PCs having this problem, I compared it to an identical PC that prints normal (same manufacturer, OS and version of Office). I made sure they both had:
[ul]
[li]Same Network Printer[/li]
[li]Same Document[/li]
[li]Same Margins[/li]
[li]Same Page Setup[/li]
[li]Same Excel Program Options[/li]
[/ul]
But still the one with the problem printed part of the next page’s title (two rows extra) at the bottom of the page. I even set them both up on Microsoft XPS Document Writer (as suggested on another site with similar prob) – no joy. I considered inserting page-breaks. It would work for one user (the one that has extra lines) but not the one who prints 2 rows short. More importantly, with 63 spreadsheets, 12 sheets each and some sheets with 20+ pages – it adds up to around 600 or so page-breaks I would have to add.
If you have read this far then I thank you. LOL Any help would be appreciated.
Eddie
