S
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
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