I am running SqlServer 2008 with Excel 2007. I have a template that an SSIS package uses to overwrite an Excel sheet, then write in data. I can write formuals like =Sum(b2:b5) on the Template and the regular Excels sheets. After I run the SSIS package
I can't run any formuals on the non-Template excel sheet.
Any help would be apreciated, thanks.
Edit: I can type values in and use fomulas on the so long as they are not in the range the SSIS has written to.
View Complete Post