slow excel: cpu or excel itself?
 

I have complex spreadsheet and my excel is very slow/crashes periodically. Is
there any way of telling if the issue is with my CPU or excel itself so I can
know if it can be remedied? Assuming it was excel how would I remedy it - is
there a way?

slow excel: cpu or excel itself?
 

Well, this is a tough one - in point of fact, it's probably not your CPU
causing the crash if it's a hardware problem at all. More likely would be
something like Excel using a portion of RAM that doesn't otherwise get used
and that could be causing a crash. A way to test the memory is to get a copy
of MemTest86+ from this site:
http://www.memtest.org/
They've got versions available for creating a bootable 3.5" floppy, and even
for a USB device, and others. Create a bootable media and use it to run the
tests to see if they indicate any memory errors. The longer you can let it
run, the better - and it'll run until you tell it to quit. Might be a good
thing to allow it to run overnight if you can.

Barring hardware issues, if it's an Excel problem, you can always try a
repair installation of Office/Excel. If you have 2007, it even comes with
diagnostics to attempt to tell if any of the Office/Excel system files have
problems that would indicate a need to do a repair install. You should also
make sure that your copy of Office/Excel has all current updates applied.
I've seen problems that caused Excel or Word to crash (not the whole system,
just the application) that got cured with an update from the update site.

"jonny" wrote:

I have complex spreadsheet and my excel is very slow/crashes periodically. Is
there any way of telling if the issue is with my CPU or excel itself so I can
know if it can be remedied? Assuming it was excel how would I remedy it - is
there a way?

slow excel: cpu or excel itself?
 

many thanks for your help

"JLatham" wrote:

Well, this is a tough one - in point of fact, it's probably not your CPU
causing the crash if it's a hardware problem at all. More likely would be
something like Excel using a portion of RAM that doesn't otherwise get used
and that could be causing a crash. A way to test the memory is to get a copy
of MemTest86+ from this site:
http://www.memtest.org/
They've got versions available for creating a bootable 3.5" floppy, and even
for a USB device, and others. Create a bootable media and use it to run the
tests to see if they indicate any memory errors. The longer you can let it
run, the better - and it'll run until you tell it to quit. Might be a good
thing to allow it to run overnight if you can.

Barring hardware issues, if it's an Excel problem, you can always try a
repair installation of Office/Excel. If you have 2007, it even comes with
diagnostics to attempt to tell if any of the Office/Excel system files have
problems that would indicate a need to do a repair install. You should also
make sure that your copy of Office/Excel has all current updates applied.
I've seen problems that caused Excel or Word to crash (not the whole system,
just the application) that got cured with an update from the update site.

"jonny" wrote:

I have complex spreadsheet and my excel is very slow/crashes periodically. Is
there any way of telling if the issue is with my CPU or excel itself so I can
know if it can be remedied? Assuming it was excel how would I remedy it - is
there a way?

slow excel: cpu or excel itself?
 

If you want to explore the possibility that it may be a hardware problem, the
folks at this site forum are pretty good at helping uncover such problems:
http://www.dslreports.com/forum/hwhelp
You don't need a membership to participate/ask questions, although creating
an account helps with some communications (you can get auto notification that
some has responded to your request for help) and the membership is free and
as a moderator of the site I can guarantee that your membership info is held
sacred and you won't get spam because of creating an account there.

"jonny" wrote:

many thanks for your help

"JLatham" wrote:

Well, this is a tough one - in point of fact, it's probably not your CPU
causing the crash if it's a hardware problem at all. More likely would be
something like Excel using a portion of RAM that doesn't otherwise get used
and that could be causing a crash. A way to test the memory is to get a copy
of MemTest86+ from this site:
http://www.memtest.org/
They've got versions available for creating a bootable 3.5" floppy, and even
for a USB device, and others. Create a bootable media and use it to run the
tests to see if they indicate any memory errors. The longer you can let it
run, the better - and it'll run until you tell it to quit. Might be a good
thing to allow it to run overnight if you can.

Barring hardware issues, if it's an Excel problem, you can always try a
repair installation of Office/Excel. If you have 2007, it even comes with
diagnostics to attempt to tell if any of the Office/Excel system files have
problems that would indicate a need to do a repair install. You should also
make sure that your copy of Office/Excel has all current updates applied.
I've seen problems that caused Excel or Word to crash (not the whole system,
just the application) that got cured with an update from the update site.

"jonny" wrote:

I have complex spreadsheet and my excel is very slow/crashes periodically. Is
there any way of telling if the issue is with my CPU or excel itself so I can
know if it can be remedied? Assuming it was excel how would I remedy it - is
there a way?