Home

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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
Highlighted
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
Highlighted

Hello @JuliaOneGoal,

did you try to replace the @ operator?

We have fixed a similar problem by replacing all @.

 

Highlighted

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.

Highlighted

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!

Related Conversations
I need the Formual...
alanaj in Excel on
1 Replies
CHALLENGE
marcialfigueroa in Excel on
0 Replies
Nested IF Statement with VLOOKUP
JCPeterson13 in Office 365 on
1 Replies
Formula needed to reorganize data
illo-guy in Excel on
4 Replies