Formula's still not calculated on file open after RemoveValue is called

Mar 24, 2011 at 8:07 PM

I have some forumlae that have a dependancy on other formulaic cells. I call RemoveValue() on the precedent cells, and they calculate just fine. Despite calling RemoveValue() on the dependent cells, they are not calculated on file open. I have tried altering the order of the calls (ie: precident cells after the dependent cells and visa versa), with no luck.

Any ideas?