Resource problem for Excel document

  • Thread starter Thread starter Paul Thomas
  • Start date Start date
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.
 
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
 
Back
Top