+ Reply to Thread
Results 1 to 2 of 2

Excel 2016 - Chart displays on screen but prints blank page

  1. #1
    Registered User
    Join Date
    02-27-2008
    Location
    Irving, Texas
    MS-Off Ver
    MS Office 2016
    Posts
    96

    Angry Excel 2016 - Chart displays on screen but prints blank page

    Hi everyone,

    I'm pulling my hair out on this one. I'm on Excel 2016, and have a workbook with 2 worksheets. It's available on DropBox at the link below:

    https://dl.dropboxusercontent.com/u/...0Analysis.xlsx

    The first sheet is 50,000 lines of data for a Monte Carlo simulation. I have a tiny macro which lets the user click a button and force the sheet to calculate. No problems there at all.

    The second sheet is a chart of the histogram of the Monte Carlo simulations. It looks great on the screen, and I'd like to share it with my colleagues.

    I've tried printing the chart to the printer, but only a blank page comes out. I've tried printing to Adobe PDF, and that also creates a blank PDF file. I've tried printing Microsoft Print to PDF, and that makes a blank PDF page. I've tried printing only the active sheet, and tried printing the whole workbook and limiting the page range to just the last page with the chart on it, and all the things I try just make a blank page.

    I cannot Copy/Paste the chart into other programs.

    The only thing I can do is use the Snip software to do a screen capture and then work from there. The screen capture works just fine for Copy/Paste, printing, etc.

    Is there some limit to the size of a file that can be printed? The total workbook is 12 MB, I presume because of the 50,000 Monte Carlo simulation rows.

    If not a size limit, is there something else that causes charts to print as blank pages?

    Any help would be appreciated.

    Thanks,
    Adam Hartman
    -Adam Hartman
    Mechanical Engineer

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Excel 2016 - Chart displays on screen but prints blank page

    Your document printed fine for me.

    What does it look like in print preview, still blank sheet?

    Have you tried printing a simple standard chart?
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro which captures screen prints of the screen when the sheet is completely minimized
    By dimple.pal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2016, 05:42 PM
  2. Excel 2016 Touch Screen
    By ftsc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2016, 01:13 PM
  3. Excel 2010 prints first extra blank page
    By kvharm in forum Excel General
    Replies: 2
    Last Post: 08-28-2012, 04:51 AM
  4. Include a separator page (blank) after a specified amount of prints
    By Papa28x4 in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2012, 08:27 AM
  5. First page prints normal, other pages print blank, why?
    By Cyberpawz in forum Word Formatting & General
    Replies: 4
    Last Post: 01-25-2012, 08:31 AM
  6. [SOLVED] When I'm trying to print a document, an extra blank page prints
    By Angie in forum Excel General
    Replies: 3
    Last Post: 08-15-2006, 03:50 PM
  7. [SOLVED] Print in Excel displays "save as" screen and never prints.
    By QA GUY in forum Excel General
    Replies: 0
    Last Post: 07-06-2006, 04:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1