How do you close one spreadsheet and keep the other open?

[Lorraine D.]

I am using two work books or two spreadsheets and when I need to close
one,both will close.Also when this happens some of the information that has
been saved is missing when I open the sheet or book I need to work in.
Any sujestions?