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.