Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Excel Printing Problems

aidan56

Likes # 0

Posted April 5, 2012 at 1:50PM

Win 7 64 bit 4GB memory Excel 2007. When trying to print a single spreadsheet of the six contained within a 5.5 MB workbook my Fineprint application says it is trying to print 4,700 pages. Another separate workbook prints the spreadsheets within it properly. All my spreadsheets are no more than 4 pages. Where have all these extra pages come from it takes ages to load.

Like this post
lotvic

Likes # 0

Posted April 5, 2012 at 2:00PM

Don't know, but as a workaround solution you could copy the six worksheet pages to a new workbook with a slightly different name and then delete the 'problem' workbook.

Like this post
aidan56

Likes # 0

Posted April 5, 2012 at 3:43PM

Thank you lotvic.

I did try this sometime ago and it seemed to correct the problem. However it's back again now. Talking to someone he suggested that all individual cells in this spreadsheet are attempting to print individually as pages.

If this is the case any idea how I can convince this spreadsheet that the cells are part of it, and not thousands of separate spreadsheets!!

Looking at it there is nothing to indicate that there is a problem.

Like this post
Simsy

Likes # 0

Posted April 5, 2012 at 6:29PM

Clutching at straws rather, but, as a simple workround, if the spreadsheet itself isn't too complex, and doesn't have macros, you could try downloading/installing either OpenOffice or LibreOffice, (virtually identical), and opening your worksheet in that...

Assuming that "fixes" the problem you could then re-save the file, as an .ods file.... the open the .ods file and re-save as .xls using Open or Libre, (whichever you've used), then reopen it again in Excel, to see if the problem has disapeared.

It might be that saving as a .ods will "strip out" the "error", which then wouldn't be present when you re-save as an .xls.

Of course this might not help at all, so apologies if it proves fruitless!

And, for safety's sake, I'd make a copy of the file before you do anything, in case something important gets lost in the conversion... but unless you've macros or complex formulae/named ranges I suspect you'll be OK.

Good luck!

Regards,

Simsy

Like this post
Simsy

Likes # 0

Posted April 5, 2012 at 6:33PM

Also... I've just thought... does this only happen when you print to "FinePrint"? What happens if you print direct to your printer?

Regards,

Simsy

Like this post
Simsy

Likes # 0

Posted April 5, 2012 at 6:37PM

And see the early posts in this thread; http://www.mrexcel.com/forum/showthread.php?t=398760

And this refers to a similar problem with Excel 2000... though the source of the problem may be similar, i.e. scaling. http://support.microsoft.com/kb/266114

I love Fineprint! I've bought it about 10 yeasr ago, and use it all the time... but I have known it to go bonkers occasionally, so the problem might be there!

Regards,

Simsy

Like this post
lotvic

Likes # 0

Posted April 5, 2012 at 6:40PM

Sorry, it's got me stumped :(

Like this post
aidan56

Likes # 0

Posted April 6, 2012 at 9:24PM

Very Many thanks lotvic and Simsy.

By the way I meant 47,000 pages not 4,700 big typo there! The whole default Excel worksheet is I believe about 1,048,575 rows or at least mine is when I press Ctrl-End, so I carried out some instructions I found on uk.answers.yahoo.com to remove one million rows below my spreadsheet working area that were not used, and that went OK. However Excel was still very very slow. Just highlighting the areas I wanted was painfully slow running at only about 2 rows per second and I had a few hundred rows. It also took ages to load into Fineprint.

FinePrint was working very well on all other spreadsheets and has given no trouble since I bought it.

I have now downloaded Open Office (thanks Simsy) and copied the areas I had used in Excel to an Open Office Spreadsheet. This worked perfectly with all required functions available. It opens very quickly and there is no problem with printing. Incidentally the whole workbook nows shows that it is only 1MB and not the 5.5MB shown in Excel.

I am very grateful to both of you for your speedy help and guidance.

Many thanks and best wishes.

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.