Thanks Ken. I have about 60 separate worksheets in the xls file. I will
have to add about 40 more, probably bringing the entire file to close to 200
megabytes! It would be nice to keep all this data in one xls file, but if
you advise me to do otherwise, well, you're the expert and I'll follow your
advice.

"Ken Wright" wrote:

Charles is as expert as you're going to find wrt this stuff:-

http://www.decisionmodels.com/memlimitsc.htm

But, I'll give you one piece of advice that I'm sure isn't necessary as you
will already have done it:-

BACK IT UP NOW!!!!

You are certainly pushing the limits wrt what most of us would generally
consider a manageable size for a spreadsheet. You don't say what is in your
workbook, but 100MB is a lot of data to lose if it goes wrong. I work with
a number of Pivot tables that are based on circa 40-50K rows of data by
around 40 columns of data. These tend to fall out at around 45/50 MB or
thereabouts, so I guess I'm curious to know what's driving the 100MB size?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Rebecca" wrote in message
...
Hi. I am using Excel 2003 on a laptop with 512 RAM and 1.2 Ghz CPU. I
have
one xls file that is now close to 100 megabytes. It opens very slowly,
but
seems to work well once opened. I was wondering if I am pushing the
limits
with such a large file. Could some of the experts in this forum please
tell
me at what point files become too large to handle? Than