poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <deshmol-li...@yahoo.com>
Subject Re: Please help - getting '#VALUE!" in Cells of 2nd sheet
Date Thu, 24 Aug 2006 19:10:10 GMT
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 <ranaaich@yahoo.com> 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:
> poi-user-unsubscribe@jakarta.apache.org
> Mailing List:    
> http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: 
> http://jakarta.apache.org/poi/
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message