2 of 2 people found this helpful
The best of 2017 to you, too!
This Excel workbook printing thing has plagued office print since 1994...well, that's at least how long I have had to answer this question, anyway.
It's well-documented on third party and Microsoft sites, but the net/net is that if your worksheets have different print settings (notably print quality and page setup), then Excel breaks the workbook into discrete jobs at each difference.
There are two ways to "fix" this. The first is to visit each worksheet and ensure that all settings are the same. If you have many worksheets, there are web resources that provide a macro to set them all at once. The other way is to SHIFT+select the worksheet tabs and then, in the Print dialog box, choose to Print Selected Worksheet(s). Oddly, this bypasses the settings conundrum, but uses the first worksheet's settings for the whole job, so proceed with caution. This Microsoft article, https://support.microsoft.com/en-us/kb/168563, includes both the synopsis of the problem as well as a Visual Basic snippet that you can use to create the needed macro.
I prefer the first way. Alternately, you can export to PDF from Excel and then print with an application that was meant to send things to a printer.
I hope this helps,
Thank you Scott! I figured this issue would come up sooner than later, and that someone had probably ran into this issue before. Glad to know there are some workarounds. I appreciate the information!