Loading External Data into Power Pivot - Microsoft Business Intelligence Tools for Excel Analysts - page 83

As you consider this option, keep in mind that there is no real data source. It's just you
manually copying and pasting. There is no way to refresh the data or to trace back where
you actually copied the data from.

Caution

Imagine you received a Word document (similar to the one shown in Figure 4-20). You like the nifty
table of holidays within the document. Here's how to import the data:

Figure 4-20: You can copy data straight out of Microsoft Word.

1. Copy the table; then go to the Power Pivot window and click the Paste button on the Home tab.

The Paste Preview dialog box opens as shown in Figure 4-21, where you can review what
exactly will be pasted.

Figure 4-21: The Paste Preview dialog box gives you a chance to see what you're pasting.