But based on the number of other users reporting similar problems, this should be a known issue by now. The file has confidential information, so in order to furnish you with a test case, I'd have to create an example from scratch, experimenting until I find what's necessary to create the bug. In this table, we have sales data with subtotals, grouped by month. Let’s look at the following example and see how to insert a page break. Several of my tabs have the same layout, and all show this bug. In Excel, we can choose when to go to the next page when printing by setting page breaks. I'm converting 11 tabs of a 25-tab Excel file many of these are two or more pages. We've used manual page breaks for a couple of years without issue. With both methods it is not always obvious to see where the breaks or print areas are set, unless you select Page Break View. Interestingly, the Insert Page break option is initially greyed out on a new workbook - but appears as soon as you type your first cell of data. I have not, thus far, found a work-around. On the Page Layout Tab, select Breaks and then Insert Page Break. The Excel file (having been saved by the Acrobat plug-in) no longer has the manual page break.The resulting pdf breaks the page about 4 rows lower, in the middle of a chart.Print Preview will show normal results.Windows 10 Pro, v 1909 (64-bit), updates are current. Bizarrely enough, when I generate the pdf from Excel, the manual page break gets removed from the Excel file.Įxcel: Office 365 Pro Plus, v 1908 (11929.20776), updates are up to date. I have this same problem, but one step worse.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |