Forum Discussion
Print variations when opened in different locations
You don't really give enough information for us to diagnose remotely (unless someone has experienced exactly the same issue, and even then it might be for different reasons). So let me ask you a few questions to get more info:
- If you don't print to PDF, but rather print directly to a printer filled with paper, does the same thing happen?
- (By the way, your use of the word "essentially" there suggests that things may not be entirely/completely the same.) What happens if, instead of using a "macro to essentially keep everything the same" you give the "print to PDF" instructions manually at home?
- Does it happen with all spreadsheets that are more than a single page?
- Does something comparable happen with Word documents, when printing to PDF?
- I'm presuming the two rows that are lost are at the bottom of the range: is that an accurate assumption? If not, where are they being lost from?
- Do the "lost rows" still appear but on the top of the next page? Or do they get lost entirely?
Let's go with those for starters, but if there's anything else that might be pertinent, please let us know.
To continue answering your questions, I did try a word document last night. In both locations, I had the same amount of rows per page at home and in the office. So no noticeable change anyway. This might just be inside of excel then?
- What is really mysterious here, if i understand your first posting correctly, is that this all happens on the same laptop computer. It's only the location--at work or at home--that changes. Is that correct?
- That's what is driving me crazy. If I were connected to a physical printer at work and then switched to PDF at home - I would get it. But same printer/driver, same computer, same print settings, same spreadsheet and I'm lost on what could possibly be happening.
There has to be some difference but for the life of me, I don't know what it could be.OK, here's a question that could very well count as "groping for an explanation"
What Excel are you using? Is it a version of Excel installed IN your laptop, or the on-line (Cloud) version? And if the on-line, does your office have a different subscription (therefore slightly different version) than you do at home?
As you say, there has to be a difference of some kind between what you're doing (where you're doing it; how you're doing it) in the two locations.