Hi guys,
So I'm trying to run a regressions using the data analysis toolpak. Everything works fine if I output the many regressions I'm running on different worksheet, but I really need them to all by outputted into one worksheet. When I chose the output range as a completely blank cell (as in 10 columns away from the first output summary) I still get an error saying "output range must be a valid reference." I don't get why it's not a valid reference.
If I click OK, I notice that the Output Range box now contains:
[MyFilename.xlsx].Sheet2!R1C1
If I click Help instead, Excel just opens the main Help window without going
to a specific section.
This happens whether I type in the output cell reference or select it with
the cursor.
Has anyone had this happen before and was able to fix it???
Bookmarks