Large excel file problems?

[gkaste]

I have a very large Excel file, about 6mb. The main cuase of that siz
is about 20 columns by 8192 rows of data and formulas analyzing tha
data (yes..I am afraid that is as compact as I can get it). The othe
causes for the size are a lot of formatting, color, text, etc, but I a
sure most of it is all the formulas. With the file size being 6mb, i
there anything to worry about as far as expecting Excel crashes, o
anything of that sort? I am using Excel 97, by the way.

Thank you

 

[Earl Kiosterud]

ghaste,

Be sure you're reset the Used Range. I spite of your large area, the
workbook file might still be larger than it should. Look at
http://www.contextures.com/xlfaqApp.html#Unused.

 

[aaron.kempf]

move to Access or a database

Excel doesnt scale well-- it isn't efficient to have 9 different copies
of the same numbers

and ARENT YOU TIRED OF MAKING THE SAME REPORT WEEK IN AND WEEK OUT?