SOLVED

Formula moves upon enter

%3CLINGO-SUB%20id%3D%22lingo-sub-2263900%22%20slang%3D%22en-US%22%3EFormula%20moves%20upon%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263900%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20experiencing%20a%20new%20issue%20in%20Microsoft%20Excel%20when%20entering%20a%20formula%20referencing%20another%20sheet%20in%20the%20same%20workbook.%20It%20would%20seem%20the%20formula%20is%20entered%20into%20the%20active%20cell%20of%20the%20referenced%20sheet.%20As%20an%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%20entered%20in%20cell%20A1%20of%20Sheet%201%3A%20%3DSheet2!%24A%241%3C%2FP%3E%3CP%3E(active%20cell%20on%20sheet%202%20is%20D1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpon%20pressing%20enter%20the%20formula%20is%20entered%20into%20cell%20D1%20of%20Sheet%201%2C%20and%20cell%20A1%20of%20Sheet%201%20is%20blank.%20The%20issue%20is%20not%20experienced%20if%20the%20formula%20is%20manually%20typed%2C%20only%20when%20entering%20%3D%20then%20navigating%20to%20Sheet%202%20and%20selecting%20cell%20A1%20and%20pressing%20enter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2263900%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2263912%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20moves%20upon%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263912%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F654628%22%20target%3D%22_blank%22%3E%40Tyler_KPAT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20can't%20reproduce%20the%20problem.%3C%2FP%3E%0A%3CP%3EIf%20you%20select%20File%20%26gt%3B%20Account%2C%20which%20version%20and%20build%20do%20you%20see%3F%20For%20comparison%2C%20this%20is%20what%20I%20get%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0278.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F271507iCA63E344C5D50C98%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0278.png%22%20alt%3D%22S0278.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am experiencing a new issue in Microsoft Excel when entering a formula referencing another sheet in the same workbook. It would seem the formula is entered into the active cell of the referenced sheet. As an example:

 

Formula entered in cell A1 of Sheet 1: =Sheet2!$A$1

(active cell on sheet 2 is D1)

 

Upon pressing enter the formula is entered into cell D1 of Sheet 1, and cell A1 of Sheet 1 is blank. The issue is not experienced if the formula is manually typed, only when entering = then navigating to Sheet 2 and selecting cell A1 and pressing enter.

 

 

 

 

4 Replies

@Tyler_KPAT 

I can't reproduce the problem.

If you select File > Account, which version and build do you see? For comparison, this is what I get:

 

S0278.png

best response confirmed by Tyler_KPAT (New Contributor)
Solution
The issue has been resolved. The culprit was an Excel add-in called Macabacus. The developer of the add-in has been contacted for correction.

@Tyler_KPAT 

Glad you found the cause!