Excel out of resources - help !

[Steve]

This is driving me mad.

And I have looked all over the net and have yet to find a solution so
this is my last chance I think.

I have a very large spreadsheet (approx 380mb in size) with roughly
36,000,000 cells of data. I have quite a few formulas but not what I
would consider very complex formulas.

I do however have a toolbar with approx 15/20 icons to use for one
click running of macros and I do use ASAP utilties as an Add-in which
I think is the only add in I have ticked.

So why do I keep getting these our of error message when I try and
calculate part of the spreadsheet?. I am only usually calculating at
most ten columns and these are only about 500 rows as I have filtered
the spreadsheet for todays date for exampe eyt I cannot even start the
calculation befire it runs out of resources.

When I look at task manager Excel is using about 1.6GB of memory
which seems huge to me.

I hvae tried the carious tricks like disabling add-ins, making sure
preview panes are off in windows explorer and excel etc but to no
avail.

The only way I can calculate the cells is by starting excel in safe
mode, calculating the cells, going into normal mode and colour the
cell bacjgrounds that I need then go back into safe mode and
recalculate then repeat this process about four times before I am
finished.

This takes for ever and is so inefficient.

Can anyone help at all, as I am at a loss to fix this

Thanks

Steve

 

[Steve]

I'm not sure if this is the reason I am running out of resources but
when do Ctrl-End on my keyboard, instead of going to the cell HP174641
the cursor goes to HP959055.

Is there any reason that is happening and if I can get the cursor to
recognise the last cell at HP17461 could this resolve my out of
resources problem ?

Thanks

Steve

 

[isabelle]

hi Steve,

you could try this and see if the last cell on the sheet is correct :

select rows 174641:1000000 and delete them
select cell A1
save file

isabelle


Le 2012-12-21 17:40, Steve a écrit :

 

[Steve]

Thanks Isabelle, although it never resolved my problem, it did work in
correcting the end cell

Cheers

Steve

 

[isabelle]

have you tried with

ctrl+t
reference: 174641:1048576 , OK
remove the lines
select cell A1
save file

isabelle



Le 2012-12-27 20:13, Steve a écrit :