Software

Move a pivot table to another workbook in Excel 2007

Excel's Move PivotTable command takes the work out of transferring a pivot table from one workbook to another. Here's a simple example that shows how to take advantage of this command.

You've just created a pivot table in a workbook and would like to publish it to your Web site. However, you don't want to publish the workbook, just the pivot table. Excel 2007's Move Pivot Table command lets you move the pivot table to any workbook on your network. To move a pivot table to a new blank workbook, follow these steps:

  1. Open the workbook containing the pivot table.
  2. Open the new workbook.
  3. Click Arrange All on the View tab, choose Vertical, and then click OK (Figure A).

Figure A

  1. Click the PivotTable report.
  2. Click the Option tab on the Ribbon under PivotTable Tools.
  3. In the Actions group, click Move PivotTable (Figure B).

Figure B

  1. In the Move PivotTable dialog box, click Existing Worksheet and then click the window shade button (Figure C).

Figure C

  1. Click A1 in the new workbook.
  2. Click the window shade button in the Move PivotTable Dialog box (Figure D).

Figure D

  1. Click OK (Figure E).

Figure E


Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks