N
Nick Danger
I have a worksheet with 320,000 rows. I make a pivot table on one of the
columns and then generate another column with sums of the values in that
colum. I then try to sort on the sum column and Excel hangs, consuming 50%
of the CPU in a dual-core processor. The only way I can get out of this is
to go into Task Manager and kill excel.exe. What's interesting is that when
this happens, excel is using 256 MB of system memory. The total memory is 2
GB; there's clearly more than 256 MB available, but something seems to think
that it can only use 256 MB. Is there a setting somewhere that needs to be
changed?
I tried running Microsoft Office Diagnostics to see if it could find
anything. All tests ran OK, but the last one (Setup Diagnostic) reported
"The diagnostic repaired all Microsoft Office installation problems it could
find." I would like to find out more about just what problems it found and
what repairs it made, but I can't find anything other than that one message.
The system Event Viewer didn't show anything.
columns and then generate another column with sums of the values in that
colum. I then try to sort on the sum column and Excel hangs, consuming 50%
of the CPU in a dual-core processor. The only way I can get out of this is
to go into Task Manager and kill excel.exe. What's interesting is that when
this happens, excel is using 256 MB of system memory. The total memory is 2
GB; there's clearly more than 256 MB available, but something seems to think
that it can only use 256 MB. Is there a setting somewhere that needs to be
changed?
I tried running Microsoft Office Diagnostics to see if it could find
anything. All tests ran OK, but the last one (Setup Diagnostic) reported
"The diagnostic repaired all Microsoft Office installation problems it could
find." I would like to find out more about just what problems it found and
what repairs it made, but I can't find anything other than that one message.
The system Event Viewer didn't show anything.