Home

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
sarr740
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
Opening the file in Excel on-line?

@Jan Karel Pieterse 

 

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

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies