Microsoft Office Tutorials and References
In Depth Information
Create a PivotTable from External Data
Create a PivotTable
from External Data
You can create a PivotTable using an external
data source, which enables you to build reports
from extremely large datasets and from
relational database systems.
Building your PivotTable directly from an
Excel table or range is convenient, but it has
two major drawbacks. First, Excel offers only
simple row-and-column database management.
Second, Excel worksheets are limited to
1,048,576 rows, so that is the maximum
number of records you can have in a range or
list data source.
To overcome these limitations, you need to
use a relational database management system
(RDBMS) such as Microsoft Access or SQL
Server. With these programs, you can set up a
table, query, or other object that defines the
data you want to work with. In most cases, the
data object can be as complex and as large as
you need. You can then build your PivotTable
based on this external data source.
1 Press Alt+D, and then
press P.
The PivotTable and
PivotChart Wizard - Step
1 of 3 dialog box
appears.
2 Select the External data
source option.
3 Select the PivotTable
option.
4 Click Next.
2
3
4
The PivotTable and
PivotChart Wizard - Step
2 of 3 dialog box
appears.
5 Click Get Data.
5
The Choose Data Source
dialog box appears.
6 Click the data source you
want to use.
7 Click OK.
7
6
 
Search JabSto ::




Custom Search