Corrupt printing of 255 column spreadsheet

[ejl10]

Hi all,

I have a huge spreadsheet that takes up all 255 columns in Excel 2000. I've cleared the print area, and forced it to print to ? pages wide by 1 page tall (it ends up being 7 pages wide). I have the margins set to a half inch all around, and no specified page breaks (I reset them just to be sure). Column A is repeated on every page. The spreadsheet is 84 rows tall.

When I print or bring up a print preview, the last column (to the right) is missing. Also, Row 2 (where I have my column titles) is correct all the way through the first 5 (of 7) pages, but the last two pages have titles that are simply repeated from earlier columns. What's really weird is that Rows 1 and 3 through the end are all correct. In fact, the columns in Row 2 don't even line up with the columns in Rows 1,3-84. Has anyone seen this before, and does anyone have any idea how to fix it? I've tried printing to three different printers, and from two different computers, but nothing works. As I said, even the print preview shows these errors. I also tried deleting 25 or so columns, and that didn't help.

Thanks,
Ejl10

 

[vconfused]

Just curious, if you turn off the Columns to Repeat, does that end the problem?

 

[ejl10]

Good question. I just tried it, and its funny- the last column now appears in the Print Preview. However, the columns in Row 2 are still corrupt on the last two pages. With A:A repeated, the spreadsheet filled up all seven pages (except, of course, for the last column). Now it saves itself about half a page, and the last column shows up. Maybe its a problem with the way Excel estimates the printable area vs. how the print driver calculates it? I guess I'm thrown off by the fact that Print Preview seems to know that the problem is there, but Excel doesn't.

Thanks for the reply. At the very least, I can now print the whole spreadsheet!

Ejl10