Excel迷你图打印问题

问题描述:

在具有多页记录的Excel 2010文档中,每行包括一个迷你图,迷你图不会打印或不会出现在打印预览中,除非先滚动整个文档以查看所有行.在我的自动生成一系列Excel报告的应用程序中,这是一个非常明显的问题.谁能为此建议修复程序,或者这是Excel 2010中的错误?

In an Excel 2010 document with more than one page of records, where each row includes a sparkline, the sparklines do not print or appear in print preview unless one first scrolls through the entire document to view all lines. In my application that produces a series of Excel reports automatically, this is a very visible issue. Can anyone suggest a fix for this or is this a bug in Excel 2010?

我知道这是一个烦人的解决方法,但是您可以在该工作簿中放置一个简单的宏,该宏在打开工作簿时便会运行,并且只需滚动到页面底部即可.工作簿,然后回到顶部. ;-)

I know this is an annoying workaround, but you could put a simple macro in that workbook that runs whenever the workbook is opened that simply scrolls to the bottom of the workbook and then back to the top. ;-)

让我知道您是否需要帮助来创建它.

Let me know if you would need help creating that.