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


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:



best response confirmed by Tyler_KPAT (New Contributor)
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.


Glad you found the cause!