Spill

%3CLINGO-SUB%20id%3D%22lingo-sub-1817714%22%20slang%3D%22en-US%22%3ESpill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817714%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20feature%20is%20such%20a%20nuisance%20and%20should%20be%20removed%20as%20it%20assumes%20what%20you%20need%20and%20I%20do%20not%20know%20how%20to%20get%20rid%20of%20it%20-%20very%20invasive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20tell%20me%20how%20to%20disable%20this%20horri%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1817714%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1817767%22%20slang%3D%22en-US%22%3ERe%3A%20Spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817767%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845794%22%20target%3D%22_blank%22%3E%40lynettem%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20disabled%2C%20the%20only%20way%20is%20write%20formulas%20in%20more%20correct%20way%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1817884%22%20slang%3D%22en-US%22%3ERe%3A%20Spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845794%22%20target%3D%22_blank%22%3E%40lynettem%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20it%20is%20just%20that%20you%20don't%20like%20change.%26nbsp%3B%20I%20assure%20you%20that%20the%20new%20paradigm%20is%20far%20better%20than%20the%20garbage%20that%20was%20traditional%20spreadsheet%20development!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20would%20like%20to%20present%20an%20example%20in%20which%20the%20dynamic%20range%20functionality%20has%20returned%20an%20incorrect%20result%2C%20in%20which%20case%20the%20community%20could%20advise%20on%20how%20it%20may%20be%20corrected.%26nbsp%3B%20Other%20than%20that%2C%20it%20is%20a%20case%20of%20sticking%20with%20increasingly%20obsolete%20versions%20of%20Excel%20and%20the%20development%20practices%20that%20they%20required.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

This feature is such a nuisance and should be removed as it assumes what you need and I do not know how to get rid of it - very invasive.

 

Can someone please tell me how to disable this horri

2 Replies
Highlighted

@lynettem 

It's not disabled, the only way is write formulas in more correct way

Highlighted

@lynettem 

Maybe it is just that you don't like change.  I assure you that the new paradigm is far better than the garbage that was traditional spreadsheet development!  

 

Perhaps you would like to present an example in which the dynamic range functionality has returned an incorrect result, in which case the community could advise on how it may be corrected.  Other than that, it is a case of sticking with increasingly obsolete versions of Excel and the development practices that they required.