From what I can tell, you can’t have pivot tables in a shared workbook, but this workbook doesn’t have multiple users in it, and it’s not a shared workbook, they just want to allow multiple copies to exist and pull the information. I finally figured it out. My guess above was correct.

Can you refresh pivot tables in a shared workbook?

At any time, you can click Refresh to update the data for the PivotTables in your workbook. You can also refresh data from a source table in the same or a different workbook.

How do I create a shared pivot table in Excel?

Step 1: Open the Excel Online sheet and select all cells containing the data you want to look at. Step 2: Select Insert > PivotTable. Step 3: From the pop-up, select New Worksheet and click OK. Step 4: In the pivot table editor, drag the rows and columns that you want to summarize to the appropriate box.

Can you share an Excel workbook with tables?

Workbooks that have tables or XML maps cannot be shared. So, be sure to convert your tables to ranges and remove the XML maps before sharing your Excel file. To be able to share a workbook, some privacy settings need to be disabled.

How do I Unshare an Excel file?

You can turn off sharing by following these steps:

  1. Display the Review tab of the ribbon.
  2. Click the Share Workbook tool, in the Changes group. Excel displays the Share Workbook dialog box.
  3. Clear the Allow Changes check box.
  4. Click on OK.

Can you change the data source for multiple pivot tables at once?

If you have several pivot tables in a workbook, and want to change all of them to a new data source, you can use a macro, instead of making the changes manually. Then, the macro prompts you to enter one of those names, as the new data source for all the pivot tables.

How do I link a pivot table to another workbook?

Import from another Excel Workbook:

  1. STEP 1: Go to Insert > Tables > PivotTable.
  2. STEP 2: Select Use an external data source and click Choose Connection.
  3. STEP 3: Select Browse for More.
  4. STEP 4: Select the Excel file with your data.
  5. STEP 5: Select the first option and click OK.
  6. STEP 6: Click OK.

How do I link a pivot table to a pivot table?

Link to a Different Pivot Table

  1. Right-click the pivot chart’s Chart area or border, and then in the popup menu, click Cut.
  2. Switch to the workbook with the pivot table that you want to use as the chart’s data source.
  3. Paste the chart back into the workbook, and delete the old copy of the chart.

How do I share a table with workbook?

Click Review > Share Workbook. On the Editing tab, select the Allow changes by more than one user check box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.

How do I share an Excel workbook with multiple users?

Set up a shared workbook

  1. Click the Review tab.
  2. Click Share Workbook in the Changes group.
  3. On the Editing tab, click to select the Allow changes by more than one user at the same time.
  4. In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.

How do I Unshare a shared Excel file?

How to unshare an Excel file

  1. We will click on the Reviews Tab, Changes group and select Share Workbook.
  2. Under the Editing tap, we will unmark Allow changes by more than one user at the same time. Next, we will select OK.