I'm having a little trouble doing some referencing to another spreadsheet. For simplicity, file "A.xls" has formulas in it that refer to spreadsheet "B.xls". However, the fields in A won't populate until I open up spreadsheet B. I've tried to write a macro to conquer this but can't. Help!! Thanks!