Post reply

Possible to populate a tab in Excel and have functions in another tab refresh

  • May 13, 2016 at 8:09 am

    #400157

    Say I have an excel file with formulas in Tab A that reference data from Tab B. I have an excel template with no data in Tab B. I copy it over to another folder and load data into Tab B but Tab A formulas don't reflect the data loaded into Tab B. Is it possible to do it in this fashion and have Tab A reflect the new data loaded into Tab B?

  • May 13, 2016 at 12:45 pm

    #1879022

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply