The source data for a PivotTable can come from any external source in any format.

Name: The source data for a PivotTable can come from any external source in any format.
Brand: Quizplus
Rating: 4.8 (25 reviews)

Question

Quizplus · Accepted Answer

The source data for a PivotTable must be organized in a tabular format, and while PivotTables can indeed use data from various external sources (like databases, Online Analytical Processing (OLAP) cubes, and external files), the data needs to be in a structured format that Excel can interpret for PivotTable functionality.

The Source Data for a PivotTable Can Come from Any