The Paste Preview dialog box enables you to see a preview of data that is copied into the PowerPivot window and to ensure that the data is copied correctly. To access this dialog box, copy table-based data in the HTML format to the clipboard, and then on the Home tab, in the Clipboard group, click Paste, Paste Append, or Paste Replace. The Paste Append and Paste Replace options are only available when you add or replace data in a table that was created by copying and pasting from the Clipboard. You cannot use Paste Append or Paste Replace to add data into a Linked Table or into a table of imported data. For more information about copying data, see Copy and Paste Data to PowerPivot.
The options for this dialog box are different, depending on whether you paste data into a completely new table, paste data into an existing table and then replace the existing data with the new data, or whether you append data to an existing table.