Excel keeps "not responding" with a fairly fast PC....

[facefox]

I am running Excel 2013 on my system. I'm using an Asus P7H55M-PRO motherboard, 4 gb of Ripjaw memory (2x2), an i7 870 Lynnfield CPU. The H55 chipset for graphics is not supported by the cpu so an older graphics card is being used until an Asus Radeon 7770 2GB GDDR5 shows up tomorrow.
The excel book I'm working on is only 812 kb in size. There are 5001 rows used in this book but only 24 columns. Right now there is only one sheet made and there are really no formulas other than "= cell so and so". Like in cell A2 the formula is =C2 and proceeds down in column A all the way from A2 to A5001. My problem is when I drag cell A2 down to A5001 to spread that formula down, it just freezes up. I keep getting the "not responding", and it is absolutely driving me nuts. There is no way I can get what work I need done with this at the speeds it is going. I have went in and turned off animations inside windows and turned off automatic calculations. Still the same thing. UGHHH! Will the new GPU help with this? If I jump up to the 16 GB of RAM it will support, will that make that stop happening? What is it I need to do? Spend about 10 grand on some super PC? Anyone have any suggestions at all?

Thank you, thank you, thank you for any help at all!

 

[kenrivers]

I have an older machine (laptop with a Q9000 Intel Core 2 Quad CPU and 6GB RAM) running an older version of Excel and have run into the same problem with a small Excel file. I said that to say that I don't believe the machine is the problem. I believe the problem lies with Excel. I have started using LibreOffice and am able to open the same file without any problems. You don't need a new GPU or more RAM.

 

[facefox]

I have an older machine (laptop with a Q9000 Intel Core 2 Quad CPU and 6GB RAM) running an older version of Excel and have run into the same problem with a small Excel file. I said that to say that I don't believe the machine is the problem. I believe the problem lies with Excel. I have started using LibreOffice and am able to open the same file without any problems. You don't need a new GPU or more RAM.

Thank you for the reply Ken! I actually opened the same file with the Kingsoft sheets, tried the same thing I did with Excel and it didn't hesitate at all. The dragging down process is quite a bit slower, but there is no hour or two wait on filling the cells. Doesn't make sense that the Excel would be so slow on a relatively small file and the Kingsoft would breeze thru it. Oh well, looks like I might be able to get my work done after all.

Thank you!!!

 

[kenrivers]

Glad I could help.