PDA

View Full Version : Excel Edit Mode Bug?



ketenshi
02-17-2011, 08:09 PM
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
02-18-2011, 02:08 AM
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
02-18-2011, 06:26 AM
Something like this could happen if both sheets were selected when the formula was entered.