I run 2010 Excel 32 bit, work are trying to get hold of 64 bit for me (running windows 7 64 bit) - hopefully that will help the situation:

I have two PCs

1st PC, i5 3470 3.2GHZ quad core, 8GB ram
2nd PC, Xeon E5-1650 v3 3.5GHZ 12 core,16GB ram

The problem is - Excel runs slower and crashes far more easily on the 2nd PC. The question is... why?

When I open a second file I get "Excel ran out of resources to calculate..." as well as a variety of other error messages

Also we've tried turning off processor cores (set affinity on task manager) as our systems guys suggested that the multi thread calculations would run quicker on fewer processors (?????)

baffled.