Intellisense disappears after a couple of seconds

[Raghu]

Hi,

I am writing an Excel VBA program and the intellisense disappears after a
couple of seconds. I am told that this is because I have some code running in
the background (in a VBA addin) that is causing Excel to recalculate formulas
and when that happens, it will make intellisense disappear. I have set the
recalculate formulas option to Manual (Tools/Options menu) and the problem
still happens. How can I make it stay?

Another side effect is that after a couple of seconds the code gets compiled
even if I am atill typing on the same line. I feel both problems are related,
but have no further clues.

Any help or suggestion is greatly appreciated.

Thanks.