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?
Bookmarks