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
CJH2012

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
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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
CJH2012

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
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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
CJH2012

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
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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
Thread Forum
Excel 2007 files are corrupted.
Hi all! Two days ago I have saved my workbooks on the mapped network drive, but now all files are corrupted.:cry: Excel tries to recover the corrupted data everytime I want to open it, but with no success. I removed all the links to external spreadsheets and read some topics with similar...
Microsoft Office
Windows 7 wont allow me to open an Excel spreadsheet
Hi, I've got a similar problem. W7 wont allow me to open an Excel spreadsheet because it says it's already running. But it isnt. It's not shown in the task manager either. How can I find it and close it apart from rebooting? This came about after I copied the the spreadsheet from a backup copy...
Microsoft Office
Excel 2010 spreadsheet taking up almost 1gb of memory
So I have a .xlsx spreadsheet of about 1.5mb taking up nearly 1gb of memory. Simple workbook consisting of about 5 sheets with standard formatting and some colors. I deleted all unnecessary rows and columns, ran 449898_intl_x64_zip hotfix, and rebuilt Excel registry and managed to get down...
Microsoft Office
Problem with Excel Spreadsheet
I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the information--the information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to...
Microsoft Office
excel & word 2007 takes 5 mins to print-sometimes 'not responding'...
windows 7 home premiun 64 bit.. office professional plus, all software is legit & upto date (service packs 1 & 2) there are 2 printers, 1 is a samsung mono & prints perfect, instantly printer 2 is an epson colour claria photo cd printer (forgot the model) 12 mths old. whenever a document is...
Microsoft Office
PDF File data into Excel Spreadsheet ?
I have WIN 7 with Excel 2003. Is it possible to transfer data contained in a .pdf file onto an Ecel spreadsheet ? If it is possible what is the procedure ?
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 19:07.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App