Читать книгу Excel Power Pivot & Power Query For Dummies - Michael Alexander - Страница 25

Organizations often install Excel in accordance with their own installation policies. In some organizations, Excel is installed without the PowerPivot add-in activated, so the Power Pivot tab won’t be visible. If you don’t see the Power Pivot tab shown in Figure 2-1, you can follow these steps to activate it:

1 Go up to the Excel Ribbon and choose File ⇒ Options.

2 Select the Add-Ins option on the left.

3 From the Manage drop-down list, select COM Add-Ins and click Go.

4 In the list of available COM Add-Ins, check the box next to Microsoft Office Power Pivot for Excel and click OK.

5 If the Power Pivot tab doesn’t appear on the Ribbon, quit and restart Excel.

TABLE 2-1 Limitations of the Internal Data Model

Object	Specification
Data model size	In 32-bit environments, Excel workbooks are subject to a 2GB limit. This includes the in-memory space shared by Excel, the Internal Data Model, and add-ins that run in the same process. In 64-bit environments, there are no hard limits on file size. Workbook size is limited only by available memory and system resources.
Number of tables in the data model	No hard limits exist on the count of tables. However, all tables in the data model cannot exceed 2,147,483,647 bytes.
Number of rows in each table in the data model	1,999,999,997
Number of columns and calculated columns in each table in the data model	The number cannot exceed 2,147,483,647 bytes.
Number of distinct values in a column	1,999,999,997
Characters in a column name	100 characters
String length in each field	It’s limited to 536,870,912 bytes (512MB), equivalent to 268,435,456 Unicode characters (256 mega-characters).