Menu
If one pastes a larger picture in an Excel workbook and then uses VBA code to print preview the sheet such as ActiveSheet.printpreview an error occurs. Only half the picture appears in the print preview window. I have made sure that page setup would print the entire picture on a single page. This error appeared after a recent update. This error does not happen using the exact same workbook in Excel 2007 or 2010. I have tried several different computers and get the same result. Has anyone else experienced this error or know the status for a fix?
Emi, To duplicate the issue, open Excel, paste a picture (enhanced metafile) that is about the height of the page. The VBA code is activesheet.printpreview. Only half of the graphic will appear in the print preview.
Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac More. To preview pages in a worksheet, simply click File > Print to preview your sheet and make any print-related adjustments. In the Print dialog box, you can use the arrows below the preview area to navigate to preview different. Nov 21, 2007 I Clicked the Print preview and excel docs showed up blank unable to print. With Print Preview Up I selected 'Setup' Then in the bottom left I adjusted print quality to anything between 300 and 2400 dpi and the preview showed up and printed fine. I have to do it for every sheet though I would love to know if I can make 600 dpi a default.
You can get the whole graphic to appear if you vastly reduce the scaling. The page breaks on the sheet, page layout view, or printing the sheet suggest that reducing the scaling to roughly 75% should not be necessary. It has been present in builds since September. My latest build is Version 1609 (Build 7369.2038). This build has a number of known issues that affect VBA controls but the issue started before this build.
In MS Word, the activedocument.printpreview works. Best Wishes, Lance.