Excel Refresh / recalculate formula without Office Installed

%3CLINGO-SUB%20id%3D%22lingo-sub-776586%22%20slang%3D%22en-US%22%3EExcel%20Refresh%20%2F%20recalculate%20formula%20without%20Office%20Installed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776586%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3Ei%20have%20a%20excel%20with%202%20sheets%26nbsp%3B%3CBR%20%2F%3Esheet%201%20-%20data%20will%20be%20loaded%20on%20daily%26nbsp%3B%3CBR%20%2F%3Esheet%202%20-%20containing%20formals%20which%20has%20reference%20to%20Sheet%201%20data%3CBR%20%2F%3E%3CU%3E%3CSTRONG%3ENote%3A%20in%20server%20Office%20is%20not%20installed%3C%2FSTRONG%3E%3C%2FU%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20question%20is%20%3A%26nbsp%3B%3CBR%20%2F%3Eas%20the%20Sheet%201%20data%20is%20changing%20(ETL%20loads%20the%20data%20into%20Sheet1)%2C%20how%20do%20i%20refresh%20the%20Formula%20in%20Sheet1%20without%20excel%2F%20opening%20it%20and%20%3CSTRONG%3Eonce%20Refreshed%20then%20SAVE%20it%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3Eany%20option%20using%20C%23%20or%20VBS%20or%20any%20method%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776586%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777322%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Refresh%20%2F%20recalculate%20formula%20without%20Office%20Installed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777322%22%20slang%3D%22en-US%22%3EOpening%20the%20file%20in%20Excel%20on-line%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777411%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Refresh%20%2F%20recalculate%20formula%20without%20Office%20Installed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777411%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20your%20response%20but%20we%20need%20do%20it%20in%20automated%20way%20and%20no%20office%20installed%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

2 Replies
Highlighted
Opening the file in Excel on-line?
Highlighted

@Jan Karel Pieterse 

 

thanks for your response but we need do it in automated way and no office installed