Excel Edit Mode Bug?

[ketenshi]

Hi All,

Here's the problem I've been having for a long time:

Lets say I have sheets: a and b

If I have selected cell a!A1 and typed "=" then clicked on sheet b and select cell A2 there, the formula for cell a!A1 should say "=b!A2" right? However, this is not always the case! Sometimes cell a!A1 will be blank and cell b!A1 will say "=b!A2" instead!

Initially I thought that this was because I was running some macros during SheetActivate but after a little bit of research, I've found that macros don't run when in edit mode.

Has anyone else experienced this problem before?

Thanks

[Bob Phillips]

Never seen that one before. It sounds like the old 12in problem, i.e the distance between the brain deciding what it wants to do, and the hands doing something else

[mdmackillop]

Something like this could happen if both sheets were selected when the formula was entered.