I don't think you are going to be able to do this in a reliable manner.

You can use a script task to connect to the workbook and force a refresh, but the API used to do so requires that MS Office be installed on the machine, and I've heard even with office installed it is not reliable on a Windows Server OS.

http://stackoverflow.com/questions/9796180/refresh-excel-using-ssis-script-task