So the answer seems to be that there is no longer a built in function in excel that will make a correlation matrix. I looked at that link and can't imagine how I'd ever get a forumula written that would deal with 34 elements over hundreds of samples. I can't tell at all how the formula mrexcel wrote works - no clue. Not a mathematician. The matrices I make in excel2003 are 34x34 and stretch across an 11x17 sheet and it only takes a couple of minutes to make them regardless of how many samples I have.

So, what's the deal here? Does no on know if excel 2010 will do a large correlation matrix or does no one want to say that it won't? I just want to know. If it won't then I just need to keep 2003 installed so I can do them. Surely someone must know the answer to this question.