Quote:
Originally Posted by close2jumping
Hi All,
I am facing the following problem in excel.
I have a formula
IF(NOT(ISERROR(C54/C57)),C54/C57,"---") in cell C60 of a spreadsheet.
Now when the sheet opens up, I see a --- in C60 even if C54/C57 is not in error.
I know that for a fact because if I manually go on cell C60, go to the formula bar, press enter, it calculates the value correctly.
Just as a side note, the formula comes to the excel sheet via a java bean.
Any help would be appreciated..
|
try this,
record macro, make it run at the time of opening workbook.
1. start macro recorder
2. place the cursor in c60
3. hit the enter key as you did
4. stop the macro
5. copy the code into workbook_open event
all the best