I have two worksheets. One is parameters and output page, and another is data, which uses parameters to calculate. Both worksheets are referencing each other. I want to separate two worksheets into two workbooks. But when I changed the parameters page without opening the data workbook, the output page doesn't update. the external reference DOESN'T work!!!