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!
Bookmarks