How to Create Table Links in Excel

1. Select the range that you would like to link.
2. In the name box enter the "item name prefix_name" For example rpt_ROISumTable (then hit enter.)
3. Click on Submit Content when you are done with linking all of your content.
Alternate method

1. Select the range that you would like to link
2. Under the home tab in Excel choose Format as Table
3. Choose OK on the Format as Table pop up that appears

4. In the Table Name box enter "item name prefix_name" For example rpt_ROISumTable (then hit enter.)
5. Click on Submit Content when you are done with linking all of your content.