Forum Discussion
Sheet Reference Issue
I often construct formulas by typing "=function..." and selecting the cell ranges by mouse or cursor. When a formula refers to a cell on the same sheet, the sheet name is not needed in the reference...
Excel has always behaved this way - once you switch to another sheet while constructing a formula, it will add the sheet name to all cell references. I assume that the developers set a flag to True when you switch to another sheet, and don't bother to reset it when you switch back to the sheet with the formula.
Although I find it mildly annoying, I have never experienced problems caused by this...
IMHO it's clearly a bug in Excel which can lead to severe consequences. Like OP I also trained myself to clean it up.
I clean it up since long ago I sorted value I was retrieving from another sheet and suddenly all values where were wrong. I didn't detect it because my total value was still good. It's only later working with a co-worker that we discovered it and all I did was wrong because of it. (It was calculation for entities and all were accounted in wrong entities...)
I clean it up since long ago I sorted value I was retrieving from another sheet and suddenly all values where were wrong. I didn't detect it because my total value was still good. It's only later working with a co-worker that we discovered it and all I did was wrong because of it. (It was calculation for entities and all were accounted in wrong entities...)