Forum Discussion
Formulas with external cell references not working`
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 fo...
Hello Scott
Are the cells in the external workbook merged cells?
Detlef,
They do not appear to be merged cells. Just to be sure, I selected each worksheet and clicked on Unmerge Cells. The problem remains.
Scott
Long shot: Could it be that the worksheets are grouped or that the worksheet is protected?
If you start Excel in safe mode (hold down the control key while starting Excel), does it still fail?
