Hi

You have your sheets grouped I think in the workbook where you paste.
Right click on one of the sheet tabs and click on Ungroup sheets

--
Regards Ron de Bruin
http://www.rondebruin.nl


"limws1" wrote in message ...
When I try to copy data from the first excel file to another worksheet in the
second excel file, the copied data appear in more than one worksheets in the
second file. As a result data in other worksheets in the second file got
overwritten with the copied data.

Anyone know why is this so? I'm using Excel 2000.