I opened one spreadsheet in sheet 1 and another in sheet 2. When I switch from sheet 2 back to sheet 1 the original spreadsheet is not the same one I began with and when I switch back to sheet 2 it is blank. Am I doing something wrong?
Maybe you have selected both tabs, so what you do in one of them is done on both.