Apr 10 2017
- last edited on
Jul 25 2018
Something has recently happened where I am unable to create formulas in one worksheet that reference cells in another worksheet unless I manually type the cell reference. If I try to create those formulas with external cell references by clicking in the reference cell in the external worksheet, some other random cell (or set of cells) is highlighted in the external worksheet and when I press Enter to complete the formula, it just returns a blank cell (in other words nothing happens).
This only happens on existing workbooks that I have. If I create new workbooks, I am still able to create such formulas by cliking on the refernce cell in the external worksheet.
Any help is greatly appreciated.
Apr 11 2017 04:24 AM
They do not appear to be merged cells. Just to be sure, I selected each worksheet and clicked on Unmerge Cells. The problem remains.
Apr 11 2017 07:19 AM
If you start Excel in safe mode (hold down the control key while starting Excel), does it still fail?
Apr 11 2017 07:57 AM
Long shot: Could it be that the worksheets are grouped or that the worksheet is protected?
Apr 16 2017 11:53 AM
What Excel version do you use?
If Excel 2010 or 2007, maybe you have opened 2 instances of the program. Or in other words: have you opened Excel twice? You cannot reference to cells in a worksheet that is opened in another instance.
Jul 06 2021 12:44 AM