P
pete
I have an interesting bug that arose some time ago in my
histogram data analysis. In generating a histogram, when I
choose a bin range and/or output range that are on a
different sheet, those ranges appear entered in A1 format.
But when I click "OK", I get an error message because the
bin range and output ranges have changed to R1C1 notation.
(When I go back to the histo tool I see those ranges in
R1C1 notation. If I change them back to A1, they revert to
R1C1 again when I click OK).
So there is no way to specify either a bin or output
range on a different sheet. My workaround is to put the
bin range on the same sheet as the data, and the output on
a new sheet, but that's not what I usually want to do.
BTW, this appears to be unrelated to the A1 vs. R1C1
option for the application, as all formulae etc. appear to
be in A1 as I prefer.
Any ideas? Thanks in advance!
histogram data analysis. In generating a histogram, when I
choose a bin range and/or output range that are on a
different sheet, those ranges appear entered in A1 format.
But when I click "OK", I get an error message because the
bin range and output ranges have changed to R1C1 notation.
(When I go back to the histo tool I see those ranges in
R1C1 notation. If I change them back to A1, they revert to
R1C1 again when I click OK).
So there is no way to specify either a bin or output
range on a different sheet. My workaround is to put the
bin range on the same sheet as the data, and the output on
a new sheet, but that's not what I usually want to do.
BTW, this appears to be unrelated to the A1 vs. R1C1
option for the application, as all formulae etc. appear to
be in A1 as I prefer.
Any ideas? Thanks in advance!