Forum Discussion

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 11, 2017

Re: Formulas with external cell references not working`

Hello Scott

 

Are the cells in the external workbook merged cells?

 

3 Replies

  • Scott Stouffer's avatar
    Scott Stouffer
    Copper Contributor
    Apr 11, 2017

    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

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 11, 2017

      Long shot: Could it be that the worksheets are grouped or that the worksheet is protected?

       

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Apr 11, 2017

      If you start Excel in safe mode (hold down the control key while starting Excel), does it still fail?

Resources