Forum Discussion
DougCooley
Sep 02, 2019Copper Contributor
"Contiguous Reference" error when using Data Analysis Tool
Greetings. I am a beginner level user in Excel and am doing a paper for my Master's Degree. I have followed a tutorial video for how to use the Data Analysis tool in Excel by using the 2 Sample t-T...
nonnahs
Mar 19, 2021Copper Contributor
I have the same problem. I reference cells in another sheet using data analysis, hit ok, and it comes up with a contagious cell reference error. When I look at the cells I referenced, it's changed completely to "Data!R2C8:R62C12"
Have you fixed your problem? If so, how?