Do both spreadsheets have the same layout? Same cell formatting, same formulas, etc.?
You're only copying values, i.e. numbers, not formulas, from one to the other, right? So, you might, for example, copy a number in cell B10 from one spreadsheet to the same cell in the other, right?