View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default file size & error checking

I would first try to find out why the error-checking is happening.

When you hover over one of the triangles what hint does it give?

Turning off error-checking does not make a file smaller AFAIK.

Perhaps you may want to try re-setting the actual used range.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Mon, 25 Sep 2006 14:27:01 -0700, runaero
wrote:

Does anyone know if turning off error checking will make file sizes smaller?
I have a spreadsheet that keeps growing is size, but only a row or two has
been added. There are a ton of the green triangles in it though.