1 Message

Digest #3009

Recalc causing strangeness -- Question Answered by "Pete A" option2z

Message

1 Recalc causing strangeness -- Question Answered

Tue Mar 18, 2014 3:13 pm (PDT) . Posted by:

"Pete A" option2z

With this awful formula, I'm getting cell content AND a popup chart into the
same cell. Ugly, but mostly works. However, a strange problem has cropped
up after using it for a few days.

=IF(B6="",IF(RCHCreateComment("None",99)="None",""),IF(ISNA(VLOOKUP(B6,'TtP
Holdings'!$B$4:$B$53,1,FALSE)),RCHCreateComment("http://stockcharts.com/c-sc
/sc?s="&B6&"&p=D&b=5&g=0&id=p01478707151",99,350,360,,,,,,B6),IF(RCHCreateCo
mment("None",99)="None","x")))

When I enter the formula above, and press enter, I get (the Green Arrow),
But when I recalculate I get the Red Arrow.

This is new to me. I have to put the cursor into the formula bar, and press
enter, 1 for each row. That gives me entries like the green arrow, but
properly CINF>.

But as soon as I save, and reopen, it's back to displaying part of the
formula.

As I wrote this email, I decided to try "ForceRecalculation" macro. That
did it.

Publishing this only because it might help others solve similar problems.

Pete A
<http://www.ttp-s.com/php/toolsmenu.php>