Move Pivot Table to Different Worksheet or Workbook (Easy Steps)

Pivot tables are very easy to create and even easier to move to some other worksheet or a new worksheet in the same Excel workbook.

Many Excel users often end up creating multiple Pivot tables in the same worksheet, which is not a very organized way of doing things.

But thanks to a readily available in-built option in Excel, you can move your existing Pivot table from the current worksheet to a different worksheet with a few clicks.

In this short tutorial, I will show you the best ways to quickly move a Pivot table in Excel.

Move a Pivot Table to an Existing Worksheet

Below are the steps to move your Pivot table to an existing worksheet in the Excel workbook:

  1. Select any cell in the Pivot Table
  2. Click on the ‘PivotTable Analyze’ tab
Click on Pivot Table Design tab
  1. In the Actions group, click on the ‘Move PivotTable’ option
Click on Move Pivot Table Option
  1. In the ‘Move Pivot Table’ dialog box that opens up, make sure the ‘Existing Worksheet’ option is selected
Make sure Existing worksheet option is selected
  1. Specify the location where you want the Pivot Table to be moved. You can use your cursor to navigate to the sheet and select the cell where you want the Pivot table to be moved
Specify the location where to move the Pivot Table
  1. Click the OK button

The above steps would instantly move your Pivot table to the specified location.

When you move up the Pivot Table, it is removed from the original location and moved to the specified destination location, so you end up with only one copy of the Pivot Table

Note that the location where you are moving your Pivot Table should be empty and there shouldn’t be any cells that already have some data. In case the cells are not empty, you will see a prompt as shown below:

Data already present prompt

Pro Tip: The keyboard shortcut to open the Move Pivot Table dialog box is ALT + J + T + V. You need to press these keys in succession (one after the other). Also, make sure you have selected any cell in the Pivot Table that you want to move before using this shortcut

Move a Pivot Table to a New Worksheet

Another useful option is to move your existing Pivot table to a new worksheet in the same Excel workbook.

When you use this option, a new worksheet is inserted, and your Pivot table is moved to this newly inserted worksheet.

Below are the steps to move a Pivot table to a new worksheet in the same Excel Workbook:

  1. Select any cell in the Pivot Table
  2. Click on the PivotTable Analyze tab
Click on Pivot Table Design tab
  1. In the Actions group, click on the Move PivotTable option
Click on Move Pivot Table Option
  1. In the ‘Move Pivot Table’ dialog box, select the ‘New Worksheet’ option
Select the New Worksheet Option
  1. Click the OK button

Can You Move Pivot Table to Another Workbook?

Yes, you can.

Just like you can move a Pivot table to another worksheet by specifying the destination location, you can also move it to another workbook by specifying the location of a cell in that workbook.

Below are the steps to move a Pivot table to another Excel workbook:

  1. Select any cell in the Pivot Table
  2. Click on the PivotTable Analyze tab
  3. In the Actions group, click on the Move PivotTable option
Click on Move Pivot Table Option
  1. Select the ‘Existing Worksheet’ option
Make sure Existing worksheet option is selected
  1. Specify the location of the workbook in which you want to move this Pivot Table. It’s best to open that workbook and use your mouse cursor to click the cell in the workbook so that it automatically picks up the location
Specify the location of the other workbook
  1. Click the OK button

The above steps would move the Pivot Table from the existing workbook to the specified workbook.

One important thing you need to remember when moving a Pivot Table from one workbook to another is that the source data remains in the original workbook and the Pivot table moves to the other destination workbook.

This link needs to be maintained for this Pivot Table to function properly. So make sure that you do not change the name of the file or delete or move that file that has the original data from which the Pivot Table was created.

In case that file is deleted or renamed, the link would be broken and your Pivot Table would stop working.

Note: While I have only covered how to move a Pivot table to another sheet or workbook in this tutorial, you can use the same process to move a Pivot Chart as well. When you click on a pivot chart, you will see the PivotChart Analyze tab, and there would be a Move Chart option in it

In this tutorial, I showed you how to easily move a pivot table to an existing worksheet in the workbook, to a new worksheet, or to an entirely different workbook.

I hope you found this excel tutorial helpful.

Other Excel tutorials you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster