I have an excel file that has VLOOKUPs into other excel files for calculations. The issue I have is that data changes in the external excel files when I import the main excel file it doesnt "recalculate" the fields that are using VLOOKUPs. Is there a way to force the calculations to happen prior to import? Currently we have to open the excel file and save it before we import it. Thanks! Craig

I think you need a Script Task as the pre-execution step in which you would implement some MS Office interoperability You must be able to find examples elsewhere to code this task out.Arthur My Blog