Hi sPhillip!
That size must be some kind of record. My recommendation would be to
invest in ways of making that workbook smaller.
Three top tips for me would be:
1. Get used range to be efficient:
Use:
Debra Dalgleish:
http://contextures.com/xlfaqApp.html#Unused
2. Replace any "use once only" formulas by their values using:
copy > edit > paste special > values OK
3. Check whether it's possible to have some material in other
workbooks.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
