Unable to go forward or back!!!

[masplin]

I have a 500,000 row table with maybe 20 measures, but unfortunately many of them are having to be looked up of another 500,000 row table of 10 columns because I'm waiting for them to be combined. I have a 64-bit machine with 10GB of RAM available. I am stuck because I cannot add any new measures wihout getting out-memory error, nor can I edit existing measures. I also can't delete columns I don't need nor remove relationships between the 2 tables that aren't needed. I tried reducing the size fo the 500,000 row table only loading 2012 data which allows me to delete/create measures. however having done my tidying up and I can load back the older data.

So I'm just stuck. Any suggestions as seems odd I can't just delete a measure out of powerpivot without it falling over?

Thanks

Mike