Excel.. File complexity and size in relation to hardware

[413x]

Having issues using my excel worksheet and was wondering what is limiting me

Atm it has several million index match formula which I am considering just using the values generated

I'm up to column xx and row 2000 in excel 2010

Just inserting a row is taking 100 seconds

I'm limited to 32 bit system, but excel is only using 1gb and 1gb is free

Am I limited by mechanical hdd, ram or cpu? It's looking like cpu as one core is working at 100%,

 

[413x]

Yes I already have manual calculations on.

I didn't quite realise how large this project was going to be. And have never used access, but yes it is mainly one large growing dataset (grows over time) containing entries wit aassociated codes. These codes require data to be associated with them via index+match that are found in a static pool of codes from an external dataset

Dataset
Code
X
Y
Z
X
Y

Code pool
Code
X-string of data
Y-string of data
Z-string of data

 

[413x]

I've just found I don't have access at work. Bit of a hassle, access looks good!

Thanks for the above offer! If I get access I'll definitely make use of that!