Forum Discussion
Excel print to PDF issue
This is clearly a problem with my files, however, there is no clear indicator as to what the issue is. I have tried everything from resetting the print areas on each page to trying multiple pdf maker apps. I have a hunch it is that page one is in portrait and the later pages are in landscape but who knows. It has worked to print these files to a printer up until today and now I cannot print to PDF. the print preview shows me all pages but when i click print, it only stops at the first one and then continues after I save the first one. Basically, I print to PDF and the program (all programs) only print the first page (the one in portrait) and then ask where I want to save the rest of the pages (the landscape pages). I do not have the time to go through hundreds of documents and do this along with the follow up of then stitching the front page and the remaining pages together as it will cost me way way way too much time. Also my morals would be broken if I stooped that low and let technology win. its 2025 and if I cannot print to pdf with multiple orientations then wtf
SOLUTION! After playing around with a bunch of different things I found the resolution. Somehow, when I was adjusting things on the front page, the DPI under the page layout tab ended up changing from 2400 to 600. I have no idea how this happened, but it caused the pages to print out separately!
5 Replies
I got the same problem. Suddenly i can not print to pdf. Every time the same error occure - A problem occurred and the workbook cannot be printed.. Fffffff..........CK! I want to kill someone. When I want to do it with small part of excel - it works. Or when I mark empty cells - works. But doesn't work with that I did thousands of times before ...... :/
HELPSOLUTION! After playing around with a bunch of different things I found the resolution. Somehow, when I was adjusting things on the front page, the DPI under the page layout tab ended up changing from 2400 to 600. I have no idea how this happened, but it caused the pages to print out separately!
Could you post one (anonymized) example file that exhibits this issue please?
PS I attached a sample report. Let me know if you got it. I dont see it here in the thread
I have searched a bunch or forums and apparently in the year 2025 we still cannot print to PDF a mix of portrait sheets and landscape sheets in one excel workbook all in one go.... I am completely blown away by this if this is true. Im hoping someone has an answer because this is a bit crazy
