Hello Experts,
This is a question about Excel (xlsx) and not sql but I think I might get some help here.So I apologize in advance but if some know knew this...
My SSIS package inserts dbsize data into excel sheet and in that excel sheet template I have last column that calculates sizes of all db which is an expression =SUM(A2:A100).
So SSIS inserts all db size successfully but then excel needs to evaluate the formula to sum all these cells but its not doing that.
For this whole cell I use General datatype in Excel.
Also I went to File-- Options--Formulas --Workbook calculation= Automatic.
Still same issues. Any idea why its not calculating?