Use these steps when you want to move an Excel worksheet from one workbook to another. Note: this steps only work in the Excel Desktop Application. There isn't a way to move or copy a tab between workbooks in Excel Online.
There are three parts to this process
Downloading the workbook that has the worksheet/dashboard you're trying to use
Moving the worksheet from the download to your Tiller-powered spreadsheet
Updating the source for the referenced links
Follow along with the demo video or the written steps below.
1. Download the workbook with the worksheet you want to move
Download the workbook that contains the worksheet you’d like to add to your Tiller-powered workbook.
If you need to update or replace a dashboard found in the Foundation Template you can download a fresh copy of the Foundation Template here.
If you're looking for community-built solutions for Excel you can find them in the Show & Tell section for Microsoft Excel here.
2. Move the worksheet into your Tiller-powered spreadsheet
Open your Tiller-powered Excel workbook.
Open the workbook you just downloaded that contains the worksheet you're trying to add.
Right click on the specific tab in the workbook you just downloaded that you want to move into your Tiller-powered workbook and click “Move or Copy”.
In the “To book” dropdown, select your Tiller spreadsheet.
Leave the “Create a copy” checkbox unchecked.
In the “Before sheet” dropdown, select “(move to end)” or choose which tab you'd like to add it before, then click OK.
Click "Yes to all" if you get a prompt about named ranges
3. Update the reference links for the new worksheet
Now that you've got the new tab in your workbook, you may notice that it's referencing data that's not yours or no data at all. That's because the formulas are still referencing the source workbook. You need to use the steps below to "edit links" and update the references to use your workbook.
Navigate to the “Data” ribbon and click the “Edit Links” button
Click the “Change Source…” button.
Navigate to the active workbook (i.e. select the spreadsheet you just copied the new worksheet into). This will point the references back to the new sheet.
At this point your new worksheet should be functional and linked to your local workbook’s data.