Microsoft Office Tutorials and References
In Depth Information
FIguRE 8-29 The Paste Preview window shows both tables when you use Paste Append.
As you can see, the product model in the Data to be pasted contains the new bike
Mountain-900, which does not exist in the original table because it is a new product.
After you paste the data in the existing table, you can analyze the merged information,
as you can see in Figure 8-30, where the Mountain Bikes category also includes the new
Although this example is a simple one, the very same technique might be applied to a
much more complex scenario that includes many PowerPivot tables, some of which might
be enriched with Excel data.