Database Reference
In-Depth Information
2. Office Shared Features installs
VSTO
4.0
, which is needed as a prerequisite for
PowerPivot for Excel.
3. To install the client application once the download is completed, run a setup program
(
PowerPivot_for_Excel.msi
), which is a self-explanatory wizard installation.
4. The initial PowerPivot installation of
Excel
2010
program requires
COM Add-ins
activation. To do so, on the Excel worksheet click File | Options and select the Add-
Ins page.
5. In the Add-Ins page from the Manage drop-down list select COM Add-ins and click on
the Go button.
6. Finally, select the PowerPivot for Excel option and click the OK button to display the
PowerPivot tab back in the
Excel 2010
sheet.
7. You can open the PowerPivot window from an Excel file, click on the PowerPivot tab
on the Excel ribbon.
8.
Launch Excel 2010 from All Programs | Microsoft Office | Microsoft Excel 2010.
On the PowerPivot tab, click on the PowerPivot Window.
9. Click on the PowerPivot Window button that will open a PowerPivot Window, as
shown in the preceding screenshot.
10. The PowerPivot Window helps you with the key operations of importing data,
filtering, and analyzing the data, as well as creating certain Data Analysis Expression
(DAX) calculations.
Search WWH ::
Custom Search