In the previous article, we saw how to import data from multiple data sources into PowerPivot for Excel. In this article, I will cover the following concepts:
- Concept of Linked Tables in PowerPivot for Excel
- Maintaining a live connection between a Working Excel file and PowerPivot using Linked Tables
Read the following articles before proceeding with this article:
To read the full article, go to this link: Creating Linked Tables in PowerPivot for Excel.