Excel 2007 : problem w/ data analysis add-in

[adamseanor]

I am trying to do some regression and correlation analysis in excel 2007 using the data analysis add-in. When I enter the input ranges (either by typing or selecting them) and then try and run the regression, i get an error that it is an invalid range. When I go back in and check my ranges, additional characters (counting up from C1 now at c18) have been added to the end of each cell reference. (i.e. Monthly!R258:R891 becomes Monthly!R258C18:R891C18

This is very frustating and I am stumped. I used this add-in many times with excell 2003 so I am pretty sure this is a 2007 issue.

Please help

[adamseanor]

Think I fixed the problem (or resolved my own stupidity - whichever way you want to look at it). Apparently, I must be in the same sheet as the data set when I run the data analysis add-in (can't retrieve data from another sheet to use). Don't remember this restriction in 2003, but hey that is life.