I am having all sorts of strange problems with the Data Analysis Toolpak Add-in. When I go to do data analysis, in this case a regression, I start trying to use the regression tool and its like excel, my computer, and my mouse are not communicating. When I try to highlight a range of values in the y-variable window, I get this strange formula:

[PROCDB.XLA]RES!$D$1:$D$500

When I am actually trying to highlight $H1:$H$500

I can type it in, but I can't use the mouse.

In addition, when I scroll around on my spreadsheet, everything gets distorted as I move it behind the data analysis window. Lines and values all over the place.

Anyone ever had these problems? Do I need to reinstall Excel?