Sheet to Sheet Cell Refs

  • I am generating a number of excel sheets from an external app. Some of the cells contain references to other sheets, however, at the point the cell is populated the sheet if references may not yet exist. In this case, excel pops up a "Find File" dialog, and populates the cell with #REF!. I want to disable this, then refresh all link when all of the sheets have been generated.

  • Have you tried turning off Calculation manaully or via macro-control? Tools-Options-Calaculation-Manual

    There is also an Update-Remote-References checkbox under this tab that can be set manually or via macro.