I tried right clicking within the original spreadsheet, also in the upper left corner that selects the entire sheet and the copy icon on the ribbon (Excel '07) and in all instances there was no 'window' that opened providing a destination choice as you suggest?