Forum Discussion
dankuchma
Aug 17, 2020Copper Contributor
dynamic arrays turn off
I am panicking because I really need to turn off the new dynamic array feature or I am ........ . I will illustrate this in an example and hope that there is a fix out there. Consider that I created ...
JKPieterse
Aug 17, 2020Silver Contributor
Instead of entering =value, enter =@value.
dankuchma
Aug 17, 2020Copper Contributor
Thanks, this worked. I noticed that I have to do this for every variable in my expression so the equations are much less clear than in the past. I am not sure how old excel documents will be adjusted. I hope that Microsoft provides an option to turn this off.
- JKPieterseOct 04, 2023Silver Contributor
dankuchma If you open an Excel file which was created in the pre-dynamic array times, Excel should automatically add those @ characters in every formula where it is needed.