i have an excel spreadhseet that imports data from an external database. the spreadsheet is set to refresh every minute and on opening. i have another spreadsheet that "VLOOKUP"s information from the first spreadsheet. the first spreadsheet does not refresh itself when it is close. is there any way i could set the 1st spreadsheet to update itself when it is closed.