I haven't found a whole ton on the web about this, but we'll have like 2 page spreadsheets (some with freeze panes) that printed fine in 2003. When we try to print, they print sometimes 700-1300 pages. I do the cntrl + end to see where the end of the spreadsheet is; looks fine to me, roughly 2 pages and nothing out of the ordinary. I have also tried the set print area tricks and that doest work either.
I'm using Excel 2016 on my Mac (v10.11) and currently working on a table for the accounting of my company. It contains two sheets: On the first sheet I list up some costs and give them a projectnr.
Any help would be awesome! Only solution now is to re-inst 2003 and print from there. This doesnt happen in all spreadsheets, just some, and not all have freeze pane. I had a similar problem once. The solution was to copy the content and paste in a brand new spreadsheet. I had tons of problems with Excel corrupting and doing weird things over the years, so I kind of gave up finding out what causes the problems. Try copying and pasting the content to a brand new sheet.
Davidg had a good point with 1 cell, but most likely if you copy everything it will print that it needs to print. Also, make sure you clear the print area. Maybe someone set the print area to the whole document. Yea I have gone through and installed the latest pcl6 drivers, that didn't work. Looks fine in print preview, just printing that is the issue. Print scaling was set to 1 to 3, and I took it off and tried printing; no dice there either.
Bi directional support I have not tried to disable yet, but I will give that a shot, also have not tried saving the workbook as 2010 workbook (we still keep 2003 compatibility) Yea and I tried printing to our other printers (hp laserjet, dell 2330dn) and it works fine. It's just these big Toshiba's. Thanks for all the support so far, I will get back to you guys with an update soon! And hopefully and answer!
Welcome to the Board! You can do several things: First, set the Print Area. Second, hopefully you don't have 65,536 rows/256 columns of data.
Excel will recognize all filled rows/columns as printable unless they're hidden or not part of the print area. You may have inadvertently set the Print Area to include the entire worksheet. As you would do with reducing worksheet size, I'd goto your last used row, Shift&End-Down, then delete those non-data rows. Same with unused columns.
That should delete the page breaks. As for additional sheets being added, how many were added and what were you you doing? If that doesn't work, post back with some more specifics.
Hope that helps, Smitty. I reset the print area and that did it. No, we dont' have all those columns and rows of data, and I am not sure how all the extra blank areas got in there. It was a spreadsheet that I had copied from another, could that possibly have had something to do with it?
The other problem, and I am not happy about this, is it is a spreadsheet that I designed for others to use and some of the others do not have much Excel experience, so who knows what might have happened. Thank you for your help, and I'm sure I will be checking back to this great resource.