A work around for is to first close out of excel entirely, then: 1. Click on Start Button. Select Devices and printers. Right click on a printer which isn't the default printer, select 'Set as Default' printer. Re-open troublesome document and attempt to choose 'Page Setup' again. Jacob you have a firm grasp of the obvious. Wassergirl - - I ran into this before, with a client who only wanted that size paper, which in VBA code is referred to as xlPaper11x17 or xlPaperTabloid. The issue is the printer(s) that are attached to the computer running the workbook. Those printer(s) (the default one or whichever you assign at the Control Panel level) must have the capability to print on that size paper. If the printer cannot print it, you won't see that size as an option in the settings. Are you sure their printer can accommodate that size? Maybe you are designing the workbook for them but on your computer, your printer is not the type that handles that size paper. That was what I ran into, so I asked my client to record a macro of them printing on that size paper, they emailed me the code, and I was able to complete the macro at my desk by recording my print macro and plugging in their VBA paper size reference from the recorded code (it's not always recorded as xlpaper11X17 or xlPaperTabloid, sometimes one or the other depending on Excel version), then sent them the finished workbook product. Maybe you are not working with VBA in this case, but just letting you know, I think it's a local system issue with printer types. Hope this helps.good luck. Rjbinney, I know it's too late to help you, but I just figured this out and wanted to post. What I did was select a virtual printer that does allow 11x17 paper, in my case Microsoft XPS Document Writer. How to search for menu items windows like mac. I just tripped over this after reading the other posts, reminding me that paper size is tied to the printer in use. Thanks everybody for giving me the idea!LittleGriff, Welcome to Mr. And thank you for taking the time to provide a solution to someone else's problem as your first post Hope to 'see' you here in the future. Rjbinney, I know it's too late to help you, but I just figured this out and wanted to post. What I did was select a virtual printer that does allow 11x17 paper, in my case Microsoft XPS Document Writer. I just tripped over this after reading the other posts, reminding me that paper size is tied to the printer in use. Thanks everybody for giving me the idea!Thank you so much for posting late. I was having this exact issue today (in 2015) as the person originally asking the question back in 2011. Your answer helped me so much!
0 Comments
Leave a Reply. |