Implicit Intersection Operator @ Breaking Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1166827%22%20slang%3D%22en-US%22%3EImplicit%20Intersection%20Operator%20%40%20Breaking%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1166827%22%20slang%3D%22en-US%22%3E%3CP%3ESimilar%20Conversations%3A%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fimplicit-intersection-operator-breaking-my-formulas%2Fm-p%2F928020%22%20target%3D%22_self%22%3EImplicit%20Intersection%20Operator%3A%20%40%20Breaking%20my%20Formulas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fimplicit-intersection-is-ruining-my-formula%2Fm-p%2F1155592%22%20target%3D%22_self%22%3EImplicit%20Intersection%20is%20Ruining%20my%20Formula%3C%2FA%3E%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3ESimilar%20to%20the%20conversations%20linked%20above%2C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fimplicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EExcel's%20update%3C%2FA%3E%26nbsp%3Bto%20insert%20the%20implicit%20intersection%20operator%26nbsp%3B%40%20is%20breaking%20my%20formulas.%26nbsp%3B%20Here%20is%20a%20very%20simple%20example.%26nbsp%3B%20Excel%20changed%20my%20formula%20%3DNUMBERVALUE(G3)%20to%20%3D%40NUMBERVALUE(G3)%2C%20creating%20a%20NAME%3F%20error%20(screenshot%20attached).%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EIs%20there%20any%20way%20to%20turn%20off%20this%20behavior%3F%26nbsp%3B%20On%20one%20of%20the%20linked%20conversations%2C%20someone%20suggested%26nbsp%3Bdisabling%20the%20%22Suggest%20formula%20variations%20that%20are%20supported%20by%20older%20versions%20of%20Excel%22%20option%20under%20Options%20%26gt%3B%20Formulas%2C%20and%20the%20user%20reported%20that%20that%20did%20not%20fix%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1166827%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1235253%22%20slang%3D%22de-DE%22%3ESubject%3A%20Implicit%20Intersection%20Operator%20-%20Breaking%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1235253%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F553448%22%20target%3D%22_blank%22%3E%40JuliaOneGoal%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EDid%20you%20try%20to%20replace%20the%20operator%3F%3C%2FP%3E%3CP%3EWe%20have%20fixed%20a%20similar%20problem%20by%20replacing%20all%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1235370%22%20slang%3D%22en-US%22%3EBetreff%3A%20Implicit%20Intersection%20Operator%20%40%20Breaking%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1235370%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%2F585520%22%20target%3D%22_blank%22%3E%40GabyS%3C%2FA%3E!%26nbsp%3B%20Yes%2C%20I%20just%20went%20in%20and%20changed%20the%20formulas%20back%20to%20what%20they%20were%20before%2C%20without%20the%26nbsp%3B%40%20operator.%26nbsp%3B%20So%20far%20it's%20been%20working%20like%20it%20used%20to.%26nbsp%3B%20My%20only%20concern%20at%20this%20point%20is%20whether%20Excel%20will%20put%20the%26nbsp%3B%40%20operator%20back%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1237561%22%20slang%3D%22de-DE%22%3ESubject%3A%20Implicit%20Intersection%20Operator%20-%20Breaking%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1237561%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F553448%22%20target%3D%22_blank%22%3E%40JuliaOneGoal%3C%2FA%3E%2C%3C%2FP%3E%3CP%3Eseems%20like%20there%20is%20some%20attribute%20saved%20in%20the%20workbook%2C%20which%20prevents%20Excel%20from%20putting%20the%20back%20in.%20But%20I%20share%20your%20concern!%20Nobody%20can%20tell%20what%20future%20updates%20will%20change!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Similar Conversations:

Implicit Intersection Operator: @ Breaking my Formulas 

Implicit Intersection is Ruining my Formula

 

Similar to the conversations linked above, Excel's update to insert the implicit intersection operator @ is breaking my formulas.  Here is a very simple example.  Excel changed my formula =NUMBERVALUE(G3) to =@NUMBERVALUE(G3), creating a NAME? error (screenshot attached).

 

Is there any way to turn off this behavior?  On one of the linked conversations, someone suggested disabling the "Suggest formula variations that are supported by older versions of Excel" option under Options > Formulas, and the user reported that that did not fix it.

3 Replies

Hello @JuliaOneGoal,

did you try to replace the @ operator?

We have fixed a similar problem by replacing all @.

 

Hi @GabyS!  Yes, I just went in and changed the formulas back to what they were before, without the @ operator.  So far it's been working like it used to.  My only concern at this point is whether Excel will put the @ operator back in.

Hi @JuliaOneGoal,

seems like there is some attribute saved in the workbook, which prevents Excel from putting the @ back in. But I share your concern! Nobody can tell, what future updates will change!