SOLVED

Formula moves upon enter

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!