Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Issue with large spreadsheet in Excel 2007: corrupted print

07 Aug 2012   #1

Windows 7 32 bit
 
 
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 System SpecsSystem Spec
.

07 Aug 2012   #2

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

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 System SpecsSystem Spec
10 Aug 2012   #3

Windows 7 32 bit
 
 

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 System SpecsSystem Spec
.


10 Aug 2012   #4

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

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 System SpecsSystem Spec
15 Aug 2012   #5

Windows 7 32 bit
 
 

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 System SpecsSystem Spec
16 Aug 2012   #6

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

Quote   Quote: Originally Posted by CJH2012 View Post
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 System SpecsSystem Spec
Reply

 Issue with large spreadsheet in Excel 2007: corrupted print




Thread Tools



Similar help and support threads for2: Issue with large spreadsheet in Excel 2007: corrupted print
Thread Forum
How do I make an Excel Spreadsheet my desktop wallpaper Themes and Styles
Excel 2010 spreadsheet taking up almost 1gb of memory Microsoft Office
Problem with Excel Spreadsheet Microsoft Office
Log files data pull - Excel,spreadsheet progamming Microsoft Office
Data from web site via YQL and load into EXCEL spreadsheet. Microsoft Office
excel & word 2007 takes 5 mins to print-sometimes 'not responding'... Microsoft Office
PDF File data into Excel Spreadsheet ? Microsoft Office

Our Sites

Site Links

About Us

Find 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 03:11 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33