When I enter a simple formula referencing cells in other sheets the formula
reverts back to my original sheet. I want to just keep clicking on the other
sheet for more cells to add the formula. What is wrong with my excel setup?