Copying and Pasting a POV

You can use the POV Manager to copy and paste a POV from one workbook to another if the data source is exactly the same for both workbooks. You must paste the copied POV to an unconnected worksheet; otherwise the POV has no effect.

  To copy and paste a POV:

  1. From the Smart View ribbon, select Function, and then Manage POV.

  2. In the left window of POV Manager, expand Active, and then select the application connection that you want to copy.

  3. From the POV Manager toolbar, click Member Selector, and then select members for the POV.

  4. Save the workbook.

  5. From the POV Manager toolbar, click Copy.

  6. In the left window of the POV Manager, expand Saved to select the workbook and worksheet (which must be blank and unconnected) that you want to paste the POV into.

  7. Click Paste.

  8. Refresh the worksheet containing the copied POV.