"Contiguous Reference" error when using Data Analysis Tool

%3CLINGO-SUB%20id%3D%22lingo-sub-833582%22%20slang%3D%22en-US%22%3E%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833582%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings.%26nbsp%3B%20I%20am%20a%20beginner%20level%20user%20in%20Excel%20and%20am%20doing%20a%20paper%20for%20my%20Master's%20Degree.%26nbsp%3B%20I%20have%20followed%20a%20tutorial%20video%20for%20how%20to%20use%20the%20Data%20Analysis%20tool%20in%20Excel%20by%20using%20the%202%20Sample%20t-Test.%26nbsp%3B%20My%20problem%20occurs%20after%20selecting%20my%20ranges.%26nbsp%3B%20As%20you%20can%20see%20in%20my%20screenshots%20that%20I%20tried%20arranging%20them%20vertically%20and%20horizontally%20with%20the%20same%20result.%20Would%20be%20grateful%20to%20whoever%20can%20tell%20me%20what%20I%20need%20to%20differently.%26nbsp%3B%20Of%20course%20it%20works%20perfectly%20in%20the%20tutorial%20video%20but%20I%20am%20obviously%20missing%20something%20somewhere.%26nbsp%3B%20Thank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129663iE55619705D869F77%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Error%20Message.PNG%22%20title%3D%22Error%20Message.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129664i89C4826E767C91D1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Scenario%201.PNG%22%20title%3D%22Scenario%201.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129662i4DB3BE0ACDE11C4D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22scenario%202.PNG%22%20title%3D%22scenario%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2222959%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2222959%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20problem.%20I%20reference%20cells%20in%20another%20sheet%20using%20data%20analysis%2C%20hit%20ok%2C%20and%20it%20comes%20up%20with%20a%20contagious%20cell%20reference%20error.%20When%20I%20look%20at%20the%20cells%20I%20referenced%2C%20it's%20changed%20completely%20to%20%22Data!R2C8%3AR62C12%22%3C%2FP%3E%3CP%3EHave%20you%20fixed%20your%20problem%3F%20If%20so%2C%20how%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402174%22%20target%3D%22_blank%22%3E%40DougCooley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2374559%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2374559%22%20slang%3D%22en-US%22%3EI%20have%20the%20same%20problem%20on%20my%20desktop%20but%20not%20on%20my%20laptop.%3CBR%20%2F%3EWhen%20I%20change%20the%20options%20to%20use%20R1C1%20referencing%2C%20I%20do%20not%20get%20the%20error%20and%20the%20ATP%20works%20well%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385492%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385492%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402174%22%20target%3D%22_blank%22%3E%40DougCooley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20share%20that%20video%20tutorial%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385716%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385716%22%20slang%3D%22en-US%22%3EIt%20was%20so%20long%20ago%20that%20I%20cannot%20access%20it%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385717%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385717%22%20slang%3D%22en-US%22%3Eso%20at%20this%20point%20your%20question%20is%20immaterial%2C%20have%20you%20solved%20that%20question%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2440375%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047584%22%20target%3D%22_blank%22%3E%40Yea_So%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESolution%3A%20In%20the%20tab%20where%20you%20have%20the%20data%20located%2C%20find%20a%20blank%20cell%20and%20start%20data%20analysis%20from%20there%2C%20rather%20than%20starting%20data%20analyses%20in%20a%20different%20tab.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFill%20out%20data%20analyses%20as%20needed%2C%20click%20%22in%20new%20worksheet%22.%20The%20data%20analyses%20will%20be%20generated%20in%20a%20new%20worksheet.%20Hope%20this%20helps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2442491%22%20slang%3D%22en-US%22%3ERe%3A%20%22Contiguous%20Reference%22%20error%20when%20using%20Data%20Analysis%20Tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442491%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076951%22%20target%3D%22_blank%22%3E%40edubs1895%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20only%20interested%20in%20the%20video%20tutorial%2C%20I%20don't%20have%20a%20dataset%20to%20analyze%3CBR%20%2F%3E%3CBR%20%2F%3Echeers%3C%2FLINGO-BODY%3E
New Contributor

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-Test.  My problem occurs after selecting my ranges.  As you can see in my screenshots that I tried arranging them vertically and horizontally with the same result. Would be grateful to whoever can tell me what I need to differently.  Of course it works perfectly in the tutorial video but I am obviously missing something somewhere.  Thank you! 

Error Message.PNGScenario 1.PNGscenario 2.PNG

7 Replies

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?

 @DougCooley 

I have the same problem on my desktop but not on my laptop.
When I change the options to use R1C1 referencing, I do not get the error and the ATP works well

Hi @DougCooley 

Can you share that video tutorial?

It was so long ago that I cannot access it
so at this point your question is immaterial, have you solved that question?

@Yea_So 

 

Solution: In the tab where you have the data located, find a blank cell and start data analysis from there, rather than starting data analyses in a different tab. 

 

Fill out data analyses as needed, click "in new worksheet". The data analyses will be generated in a new worksheet. Hope this helps!

 

 

@edubs1895

I was only interested in the video tutorial, I don't have a dataset to analyze

cheers