About Us

bala_vb

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Odd Excel Formula Problem	Questions	New Users to Excel	1	December 15th 09 07:54 PM
problem with excel formula	L. Wilson	Excel Worksheet Functions	1	June 18th 08 02:40 AM
Excel formula problem	Oregon Sailor	Excel Discussion (Misc queries)	2	April 24th 07 05:10 PM
Excel Formula Problem	prasanta	Excel Discussion (Misc queries)	1	April 22nd 06 03:46 AM
EXCEL FORMULA PROBLEM	detlghtpd	Excel Discussion (Misc queries)	1	April 7th 05 12:22 AM

Menu

About Us