Jul 28 2019 10:21 AM
Hi,
i have a excel with 2 sheets
sheet 1 - data will be loaded on daily
sheet 2 - containing formals which has reference to Sheet 1 data
Note: in server Office is not installed
the question is :
as the Sheet 1 data is changing (ETL loads the data into Sheet1), how do i refresh the Formula in Sheet1 without excel/ opening it and once Refreshed then SAVE it?
any option using C# or VBS or any method
Thanks
Jul 29 2019 05:22 AM
Jul 29 2019 06:28 AM
thanks for your response but we need do it in automated way and no office installed :(