All,

I've built a relatively large (6mb) s/sheet that has a penchant for crashing. There are no macros in the sheet, just a large number of formulas that link to external workbooks.

It seems that the sheet may crash more when in auotfilter mode.

Is there any de-fragging or other tricks that people know to stop/reduce the crashing incidences. If it of any use, I have a laptop with MS XP (perhaps I can do something on XP that I can't do on 97?) , but would have to return the files to the main network (only has excel97)

If I have to resort to copying to a new workbook, are there any things I shoul/shouldn't do?

Help much appreciated!