Based on Excel 2007, when you paste between workbooks, you need to use Paste Special (under the Home tab for 2007) and select Paste Special so if you want to paste something in a new workbook without the whatever in the old workbook from coming over, too

Otherwise, your basic Paste copies over any formatting, etc, from the old workbook; ergo, why you use Paste Special