title: Excel reference to other sheet fails
body: <h2>Error</h2>
  
  <p>When referencing from one sheet to another sheet within a workbook, while navigating to the target cells and ranges, a reference is placed in another cell in the first sheet, often with #REF in it. See details below.</p>
  
  <h2>Questions</h2>
  
  <ul>
  <li>How can I remove this bug?</li>
  <li>Or isn't it a bug an just a setting in Excel that I changed
  unintentionally?</li>
  </ul>
  
  <p>I have tried to fix the error (see 'My fix failures' below). Currently I see no other option than completely reinstall my PC, but I am afraid the bug is in the old files. </p>
  
  <h2>Details</h2>
  
  <p>Some of the actions that I have observed are (but not limited to):</p>
  
  <ul>
  <li>I'm entering a formula in a cell while navigating to the target cells
  or ranges. So far so good, but when I hit enter, the formula I
  entered appears in a different cell than the one I was entering the
  formula in, overwriting the original content.</li>
  <li>The reference seems to 'land' on a random cell, replacing an existing cell, but it seems to land in that same cell whenever I try to make a reference from a different cell in the same sheet and a different cell in the target sheet that I am referring to.</li>
  <li>Within the same sheet, I can not make a new reference to another sheet. When I remove the first reference and replace it with a new reference to another sheet, it 'lands' on a new cell. Oddly, there is a new reference in the target sheet as well.</li>
  <li>The error occurs while I am putting in
  
  <ul>
  <li>Normal references: ='sheet 2'!A7</li>
  <li>Index references: =INDEX(Sheet2!$B$3:$F$7;Sheet1!B3;Sheet1!C3)</li>
  <li>VLookup references: =VLOOKUP(B3;Sheet2!A3:F7;Sheet1!C3+1;0)</li>
  </ul></li>
  <li>It seems to occur in older files only. I just made a new file and could not reproduce the error.
  
  <ul>
  <li>The problem does not occur in Excel 2007 on my laptop while working in the same old files that show this problem on my desktop. </li>
  </ul></li>
  </ul>
  
  <p>I fail to detect the system in the error.</p>
  
  <h2>My fix failures</h2>
  
  <p>I have been experiencing this error for some time now and tried these options:</p>
  
  <ul>
  <li>Searching this forum and others, via Google a.o.</li>
  <li>Cleaning up the registry (CCleaner, Avira speed-up)</li>
  <li>Reparing Excel 2007 (Professional)</li>
  <li>Removing Office 2007, upgrading from Windows 7 to 10, reinstalling Office 2007</li>
  </ul>