How to Connect to a Hub

Overview

This guide describes how to connect an Excel table to an existing hub. Below are the pre-requisites to connect to an existing hub.

The hub to connect to must already exist
The table to be connected to the hub must have the same columns as in the database
The name of the Excel table you want to connect to the hub must be the same as the original hubbed table.

Audience

Users of XLhub who will need to consolidate multiple files with same column structure.

Flow of Events

1. Define a Table

Before using XLhub, you need to transform your data into a table:

Open the Excel sheet with the data you want to hub.
Select the data you wish to create into a table. Be sure to include the column headers in your selection, as shown.
Once selected, click the Insert tab and, in the Tables section of the ribbon, hit Table. Alternatively, press CTRL+T as a shortcut.
When you have clicked Table, a dialogue will appear. Be sure that the check box “My table has headers” is checked.
Click OK.

Your data should now be formatted as a table, and look something like this.
Enter the same table name as the one you want to connect to by clicking on Table Tools at the top of your page while your table is selected, and then entering your name in the field in the upper left corner (in the Properties section of the ribbon).

NOTE: Use the same name table that you used for the previously hubbed table (the one you want to connect to). If it is not the same name the wizard will not enable connection and will just allow creating a new hub.