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