Excel cannot complete this task with available resources

B

BillJenk

I have a very large workbook that runs OK in Excel 2003. However, when I go
to print some worksheets I get the message "Excel cannot complete this task
with available resources." Is there anything I can do to prevent this
problem.

Thanks for your help!
 
J

Jan Karel Pieterse

Hi BillJenk,
I have a very large workbook that runs OK in Excel 2003. However, when I go
to print some worksheets I get the message "Excel cannot complete this task
with available resources." Is there anything I can do to prevent this
problem.

Clean up your workbook as much as you can:
- simplify formatting
- use styles instead of formatting without a plan
- consider if you really need all charts
- for all charts un check the auto scale font box on the font tab
- check whether the last used cell of each sheet corresponds with the data
- check if there are objects on sheets you did not know about (F5, special,
objects, tab through them, repeat on each sheet)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
B

BillJenk

Thanks for your help. I have already tried some of your suggestions to no
avail. It is just so frustrating as the programing of this workbook works
fast and very smoothly but I keep running into problems printing 3 worksheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top