Resource problem for Excel document

P

Paul Thomas

Problem with Excel document

Error message

"Not enough system resource to display completely".
will not show proper color or display correct fonts.
PC slowing down to a crawl.
also getting not enough memory message, this problem has
also been reported on another PC.
 
N

Nikos Yannacopoulos

Paul,

Your workbook size must have got out of control! How big is it?
If you think it's a lot bigger than you'd expect, then open it on a powerful
machine and copy everything to a new workbook (don't use save as). The new
copy may prove to be a lot smaller!
If it's (a) huge worksheet(s) with long, complicated formulae repeated in
hundreds or thousands of lines, you'd probably be a lot better off
substituting them with user defined functions in VB, if you can.

Remember: charts make it heavy, lots of formatting (lines, colors etc) make
it heavy, pictures (do you have a bitmap logo in there, maybe?) make it
heavy. If nothing else works, see if you can save on these.

HTH,
Nikos
 
Top