Data corruption on alternate sheets?
When working with multiple sheets, are there any operations one should avoid?
Twice now, I've had workflow which goes like:
* Work on sheet A of a workbook for a while
* Switch to sheet B, work on it for a while
* Switch back to sheet A, find it decidedly not in the state that I left it in (eg, missing data in cells or row / values on wrong row).
At first I thought it was that "delete row" or "delete column" was applying to all sheets, but it doesn't seem to be that simple when I go back and look through the history (which doesn't seem to quite match my recollection of the edits I made).