Carl
How big is your file? The most common cause of a file "growing" out of
proportion is where Excel thinks the last used cell is vastly different that
what it really is. Do this: In each sheet, scroll to the last cell (last
row and last column). Note the cell address. Then do Ctrl-End. Excel
shows you what it thinks is the last used cell. If those 2 cells are vastly
displaced from each other, that might be your problem. Note that the size
of the file is predicated on, among other things, the size of the used
range. Post back with your findings. HTH Otto
"carl" wrote in message
...
I am creating a new spreadsheet from data from another spreadsheet. It is
basically a subtotal spreadsheet but the process of subtotalling is much
more
complex because some of the data can be subtotalled and other columns are
just info. So I'm using v-lookup and various other formulas to copy the
data
over. The problem is that I've hit a point where Excel has told me:

Excel cannot complete this task with available resources. Choose less
data
or close other applications.

I have to say that I don't think that I should be getting this message
because even though some of the stuff that I'm doing is complex there
isn't
much data there and I'm always getting rid of the formulas by copying and
pasting the values over the formulas.

Can anyone help?