I'm receiving a divisional symbol with a formula that I'm using to pull over data from another workbook that is not open. If I open the workbook the divisional symbol disappears. Why does the workbook need to be open in some cases, and not others in order to update properly?