Excel Not Responding

[Floydene]

I am working in a largish Excel file on Windows XP. It's about 312,000
records long. I am trying to delete the last 50,000 or so records and
everytime I select the records and hit delete, Excel gets hung up and I have
to force quit. Same thing when I try to do a Find/Replace on one of the
columns. I tried rebooting my machine. My husband suggested turning off our
security software, since it is new and perhaps the cause of the problem?
Anyone else have a similar situation?

Many thanks in advance,

 

[Sean Timmons]

If you have a lot of formulas either in the sheet or that calc off yoru
sheet, you can go to Tools > Options > Calculation > Manual

then, you can do your deletions or Find/Replaces and change back to automatic.

 

[Sean Timmons]

If you have a lot of formulas either in the sheet or that calc off yoru
sheet, you can go to Tools > Options > Calculation > Manual

then, you can do your deletions or Find/Replaces and change back to automatic.

 

[Gord Dibben]

What is actual file size in MB or KB? Not the number of records.

How much RAM do you have?

What happens if you select 10,000 records and try to delete them?


Gord Dibben MS Excel MVP

 

[Gord Dibben]

What is actual file size in MB or KB? Not the number of records.

How much RAM do you have?

What happens if you select 10,000 records and try to delete them?


Gord Dibben MS Excel MVP

 

[Floydene]

Sean and Gord,

Thanks to you both for responding to my post. The answer, it turns out,
related to a security pack that I had not yet downloaded for XP following
replacement of my MB. Once I installed the security pack, I was able to
search and replace tens of thousands of records in seconds without having
Excel crash afterward.

Again, I thank you for responding to my plea.

 

[Floydene]

Sean and Gord,

Thanks to you both for responding to my post. The answer, it turns out,
related to a security pack that I had not yet downloaded for XP following
replacement of my MB. Once I installed the security pack, I was able to
search and replace tens of thousands of records in seconds without having
Excel crash afterward.

Again, I thank you for responding to my plea.

 

[Floydene]

Sean & Gord:

Thanks for responding! The solution lay in a service pack (is that what
it's called?) that I had not downloaded after purchase of a new computer last
month. But now we're up and running again.

Thanks again!

 

[Floydene]

Sean & Gord:

Thanks for responding! The solution lay in a service pack (is that what
it's called?) that I had not downloaded after purchase of a new computer last
month. But now we're up and running again.

Thanks again!

 

[Sean Timmons]

Yes, that is a service pack. Good to know that fixed it! Thank you for the
update!

 

[Sean Timmons]

Yes, that is a service pack. Good to know that fixed it! Thank you for the
update!