Excel迷你图打印问题 [英] Excel sparklines printing issue

问题描述

在具有多页记录的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.

这篇关于Excel迷你图打印问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！