M
monir
Hello;
1) I've noticed recently that opening the same simple w/b and Enable Macros,
ALL values on the active w/s would momentarily display correctly, and then
(generally speaking) the cells containing formulas (e.g.; =SUM(A1:A10)) would
display FALSE and those containing references would display False.
(I'm not using any volatile functions such as NOW, TIMMER, RAND, etc.)
2) Pressing F9 would remove "some" of the displayed False, despite the fact
that the Tools::Options::Calculation::Automatic is checked.
3) Selecting a cell with displayed FALSE, and pressing Enter would replace
False with the correct value.
4) If I select one of those False displayed cells, and in the Formula Bar
press fx, it would display:
....Formula result = volatile
Can someone please shed some light on what going on ??
Thank you.
(XL 2003, Win XP)
1) I've noticed recently that opening the same simple w/b and Enable Macros,
ALL values on the active w/s would momentarily display correctly, and then
(generally speaking) the cells containing formulas (e.g.; =SUM(A1:A10)) would
display FALSE and those containing references would display False.
(I'm not using any volatile functions such as NOW, TIMMER, RAND, etc.)
2) Pressing F9 would remove "some" of the displayed False, despite the fact
that the Tools::Options::Calculation::Automatic is checked.
3) Selecting a cell with displayed FALSE, and pressing Enter would replace
False with the correct value.
4) If I select one of those False displayed cells, and in the Formula Bar
press fx, it would display:
....Formula result = volatile
Can someone please shed some light on what going on ??
Thank you.
(XL 2003, Win XP)