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 dataNote: 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
@Jan Karel Pieterse
thanks for your response but we need do it in automated way and no office installed