I've got an xlsm file with a bunch of plots on one of the worksheets. I want to print that worksheet to PDF. There's a ton of data being plotted, and in the past it's always worked fine.

Recently, I cleared out 95% of that data. The plots now contain much less data. However, when I print to PDF, it now takes 5 minutes to do, and the filesize is about 10MB, instead of 1.5MB. This makes no sense.

No, there is no other data in any cells on the worksheet. Absolutely nothing with the worksheet has changed, because the data being plotted is in its own separate worksheet.

Any ideas? I have no clue how I would google this.

[Edited on April 8, 2010 at 1:19 PM. Reason : ]

4/8/2010 1:18:57 PM

are you using an external PDF printer or the save as pdf option office 2007?

4/8/2010 1:21:35 PM

External PDF printer.

4/8/2010 1:25:17 PM

give this a try: http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041&displaylang=en

4/8/2010 1:28:07 PM

Already have that capability but the result is REALLY screwy if I use it. For example, one of the plots has data not displayed because the axes are constrained....so the trend actually goes OUT of the chart, and through the rest of the document. Very strange. The external at least produces something logical. Thanks though.


Okay, so after trial and error it appears that the tighter I make the x-axis, the bigger the file gets. Doesn't make sense....less data on the plot, less data, should be smaller file.

[Edited on April 8, 2010 at 1:52 PM. Reason : ]

4/8/2010 1:30:29 PM