CTRL SHIFT ENTER Stopped working - Instead of Array It Opens Up Document Folder

[DR RENO]

https://www.dropbox.com/s/u1h5kie2ygi79xy/N Plain Disappearance_7JUL18.xlsx?dl=0I've copied worksheet array formulas to new sheet and pasted formulas. Modified arrays on worksheet fine with no problems. Replicated that process to 3rd worksheet. First half of worksheet allowed me to modify with no problem. Then when I went to section that had new worksheet to link, ctrl shift enter no longer created array. Instead it would open up document window. The worksheet I'm adding is in the spreadsheet.

Please see sample file Soybeans worksheet cell I3 - the new sheet to link is S IMP_EXP to replace W IMP_EXP and Soybeans to replace Wheat. J3 also gives same problem when attempting to modify array

 

[admiral100]

Hi,

[FONT=&quot]Maybe because the workbook/worksheet where you put the formula in does not exist ....? [/FONT]

 

[Aladin Akyurek]

[…]
Please see sample file Soybeans worksheet cell I3 - the new sheet to link is S IMP_EXP to replace W IMP_EXP and Soybeans to replace Wheat. J3 also gives same problem when attempting to modify array

Substituted the sheet name S IMP_EXP. This action simply succeeds over here and the following results appear...

[TABLE="class: grid, width: 411"]
<tbody>[TR]
[TD]DEC ON FARM STOCKS[/TD]
[TD]MAR OFF FARM STOCKS[/TD]
[/TR]
[TR]
[TD]150,000,000[/TD]
[TD]115,000,000[/TD]
[/TR]
[TR]
[TD]165,000,000[/TD]
[TD]130,000,000[/TD]
[/TR]
[TR]
[TD]40,000,000[/TD]
[TD]40,000,000[/TD]
[/TR]
[TR]
[TD]54,000,000[/TD]
[TD]24,500,000[/TD]
[/TR]
[TR]
[TD]409,000,000[/TD]
[TD]194,500,000[/TD]
[/TR]
</tbody>[/TABLE]

which look the same as the results before the substitution.

 

[DR RENO]

@Aladin Akyurek

Thank you for taking a look, but the formula also needs substitution of Soybeans (the active sheet) for Wheat. The combination is not allowing ctrl shift enter to add array, but instead opening up document folder. I originally created Corn tab then performed subs to create wheat. Same process worked for Soybeans until I get to columns I and J

 

[DR RENO]

I decided to make the subs incrementally. Somehow that allowed me to build out the array successfully. Not sure what caused issue, but working now. Thank you guys for your help

 

[Aladin Akyurek]

@Aladin Akyurek

Thank you for taking a look, but the formula also needs substitution of Soybeans (the active sheet) for Wheat. The combination is not allowing ctrl shift enter to add array, but instead opening up document folder. I originally created Corn tab then performed subs to create wheat. Same process worked for Soybeans until I get to columns I and J

I did the substitution in the Soybeans sheet...

I decided to make the subs incrementally. Somehow that allowed me to build out the array successfully. Not sure what caused issue, but working now. Thank you guys for your help

Apparently sorted out. That's what counts.