Solved Issue with large spreadsheet in Excel 2007: corrupted print

[CJH2012]

Hi,
I have been using Excel intensively for the past month for a 'volunteer' local project/event we are putting on here.
I now find I have a created a spreadsheet bigger than any I have ever used before.
It works great, except when I try to print it. It says it's preparing to print 100 -or more- pages (when there are only 6) which takes about 2 MB.
I had printed if successfully, and successively (since I need regular hard-copies to work on with other people), up to the end of last week.
I have also noticed the first page contains an almost microscopic rendition of the first worksheet, and subsequent sheets have various unrecognisable printings across them.

It is not my only spreadsheet, and the other ones (mostly just one page or extracts of the larger one) print fine. So it is not my printer.

Any suggestions gratefully received!

 

[GEWB]

Hmm, think out loud...

My Excel 2007 print function defaults to "Quick Print" which sends the entire workbook to the default printer. Could that be a reason?

How many columns and rows is the worksheet in question?

Regards,
GEWB

 

[CJH2012]

About 70 rows and 20 columns on the 'main' page, and less than that on the subsidiary pages.
I begin to doubt I will have to finally re-install Windows afresh because of various issues- see my other thread here

I have the box selected for "Print Active sheet" but it ignores this and tries to print pages and pages of garbage. When I insist on printing only one sheet by selecting "Print from sheet [1] to sheet [1]" as I said before it tries to print my spreadsheet in about size 3 font and compressed into top left corner.

 

[GEWB]

Not sure about a solution. If you want to send me your file I'll take a look but I'll need to do it in the next two days (no access next week). If so, PM me on this forum.

Regards,
GEWB

 

[CJH2012]

Hi, Thanks, this is solved- A few cells had duplicated themselves across hundreds of cells-not sure how this happened- I hadn't realised at first because there was spacing in between the duplications.
Hence Excel tried to print my main spreadsheet crammed into one corner and microscopically small because I has set it to "Fit spreadsheet to one sheet of A4 paper".

 

[GEWB]

Hi, Thanks, this is solved- A few cells had duplicated themselves across hundreds of cells-not sure how this happened- I hadn't realised at first because there was spacing in between the duplications.
Hence Excel tried to print my main spreadsheet crammed into one corner and microscopically small because I has set it to "Fit spreadsheet to one sheet of A4 paper".

Now THAT would do it! Glad you found the issue.

Regards,
GEWB