excel issue - calculating formulas are not happening automatically
I am using Microsoft excel 2010. Values are getting downloaded from
database and I am writing them on to excel. I have some formulas written
in excel itself. So, my formulas would be using the values downloaded from
excel and showing the value of formula in one cell. But for some reason,
the value is not showing automatically and I need to press ALT+CTRL+F9 to
see the value (calculated using formula of that cell).
Can anyone tell me is there any other way to avoid pressing ALT+CTRL+F9 ?
downloading all the values and writing in excel is happening through java,
hibernate.
Thanks in Advance,
No comments:
Post a Comment