Check whether you have Tools > Options > [calculations_tab] > Calculation
...set to "Automatic". Alternatively, you can also use F9/Shift+F9/Ctrl+Alt+F9/Ctrl+Alt+Shift+F9 to evaluate all changed formulae in the sheet (look up the excel help for details/differences of each key combination. ~ amol --- Rana Aich <[EMAIL PROTECTED]> wrote: > Hi, > > I'm generating an Excel File with two sheets : > Sheet1 > and Sheet2. In Sheet1 I've calculated few formulas - > and they are working fine. > > In the Sheet2 I put formulas based on values on > Sheet1. But instead of getting the Proper Values I'm > getting "#VALUE!" in all the cells. Interstingly > after > clicking the individual cells in Sheet2 and pressing > the "Enter" key, the Cell value is shown. > > How can I obtain the proper values in the cells of > 2nd > sheet instead of "#VALUE!"? > > Thanking you all in advance. > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > Mailing List: > http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: > http://jakarta.apache.org/poi/ > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
