Issue with large spreadsheet in Excel 2007: corrupted print


  1. Posts : 30
    Windows 7 32 bit
       #1

    Issue with large spreadsheet in Excel 2007: corrupted print


    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!
      My Computer


  2. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #2

    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
      My Computer


  3. Posts : 30
    Windows 7 32 bit
    Thread Starter
       #3

    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.
      My Computer


  4. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #4

    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
      My Computer


  5. Posts : 30
    Windows 7 32 bit
    Thread Starter
       #5

    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".
      My Computer


  6. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #6

    CJH2012 said:
    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
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 15:43.
Find Us