Formula of excel not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1716627%22%20slang%3D%22en-US%22%3EFormula%20of%20excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716627%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI%20have%20one%20Excel%20file%20with%20two%20worksheet%20i.e.%20WS1%20and%20WS2.%3CBR%20%2F%3E%3CBR%20%2F%3ESome%20external%20process%20adding%20values%20in%20WS1%20and%20it%20was%20refrences%20by%20Col%20A%20of%20WS2%20say%20formula%20%3D%20WS1.A1-%20WS1.A2..%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20then%20Col%20A%20of%20WS2%20is%20used%20in%20report.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20the%20problem%20is..Report%20not%20showing%20updated%20data%20for%20Col%20A%20of%20WS2%20(WS1.A1-%20WS1.A2)%20I.e.%20however%20Columns%20of%20WS1%20(%20A1%20and%20A2)%20are%20updating%20successfully%20.once%20I%20open%20excel%20file%20and%20closed%2C%20report%20started%20showing%20expected%20data%20of%20WS2%20columns%20as%20well.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20excel%20formula%20only%20works%20when%20file%20refresh%20manually%20%2C%20will%20it%20not%20work%20if%20file%20remain%20closed.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20suggest!!%3CBR%20%2F%3EThanks%3CBR%20%2F%3EAmit%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1716627%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor
Hi,
I have one Excel file with two worksheet i.e. WS1 and WS2.

Some external process adding values in WS1 and it was refrences by Col A of WS2 say formula = WS1.A1- WS1.A2..

And then Col A of WS2 is used in report.

Now the problem is..Report not showing updated data for Col A of WS2 (WS1.A1- WS1.A2) I.e. however Columns of WS1 ( A1 and A2) are updating successfully .once I open excel file and closed, report started showing expected data of WS2 columns as well.

Is excel formula only works when file refresh manually , will it not work if file remain closed.

Please suggest!!
Thanks
Amit
1 Reply
Highlighted

@amsrivas28 

Nope, if you are in automatic calculation mode

image.png