EPPLUS : Is it possible to get calculated values from macro enabled excel file(.xlsm)??

May 6 at 9:51 AM
Hi,
I am trying to get the calculated value of the particular cell which has not simple formula like this Cell C =(1+A1+B1), It has easily calculated to call Calculate(). But if cell has reference of another sheet in the place of simple fomula, this one not calculating, i am using Calculate() to calculate this but the result is 0.

I have provided the excel which has lot's sheet. I need to care about only one MainSheet. In this sheet i need to put the value get the corresponding output. Some where cell has simple formula which is working fine , but somewhere cell has reference another worksheet this one getting problem for me. i am not getting exact result.. Please help me . Is there any solution ??