As it turns out the SUMIF-ing isn't the problem in itself. It is that the
sumif points to linked cells that is the problem. Once I pointed the SUMIF
to the original spreadsheet field it was instantaneous.
Thanks for your response anyway,
Marina
"Niek Otten" wrote:
I meant:
Sumif-ing 65535 ROWS may take quite some time.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Niek Otten" wrote in message
...
Hi Marina,
Sumif-ing 65535 may take quite some time.
Test to see whether
=SUMIF('First Worksheet'!D3:D20,"Michael",'First Worksheet'!I3:I20)
does work
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Marina" wrote in message
...
I have an issue where whenever the cells on a worksheet are selected for
re-calculation, it gets "stuck" at 0% and causes Excel to stop
responding.
The spreadsheet is designed to do the following:
- First worksheet lifts data from another spreadsheet via link function.
- Second worksheet calculates totals based on the data in the first
worksheet. For example, calculations include things like:
=SUMIF('First Worksheet'!D:D,"Michael",'First Worksheet'!I3:I65535)
This is done to sum all of Michael's entries and is repeated for each
person.
There is then a total to sum entries for groups of people.
I have tried re-calculating based on auto and manual with the same
results.
The CPU appears to max out at 100% and the application hangs.
I am running WinXP SP2, Excel 2003, P4 2.4Hz, 512MB RAM and have
downloaded
all Excel 2003 updates.
Just as a sidenote, if I re-create the formula in a new cell it
calculates
instantly. Is it possible that the formulas need to calculate in a
certain
order and this is causing the problem?
I would appreciate any help you can offer with this problem.
Marina
|