Hi,
Power Pivot is available to all versions of office 2010.
Check to make sure your system meets the requirements below...
System Requirements
Supported Operating Systems:Windows 7
Windows Server 2008 R2 (64-bit),
Windows XP with SP3 (32-bit),
Windows Vista with SP2 (32-bit or 64-bit)*,
Windows Server 2008 with SP2 (32-bit or 64-bit)*,
Windows Server 2003 R2 (32-bit or 64-bit) with MSXML 6.0 installed+ ,
Terminal Server and windows on Windows (WOW)-- which allow you to instal 32-bit versions of Office 2010 on 64-bit operating system-- are supported.
* Also requires Platform Update for Windows Vista/Windows Server 2008.
+ Only 32-bit Microsoft®Office 2010/PowerPivot for Microsoft® Excel 2010 is supported on 64-bit Windows Server 2003 R2.
500 MHz 32-bit or 64-bit processor or higher
Minimum of 1 GB of RAM (2 GB or more is recommended.)
3.5 GB of available hard disk space
Look here for an explanation by MrExcel himself on how great this tool is...
http://www.youtube.com/user/bjele123#p/search/14/ms149Qi2PVA
You can download Power Pivot from here....
http://www.microsoft.com/downloads/...94-e4ab-42df-8c87-4b99c1f3c49b&displaylang=en
Yes, you can also use (learn) Macros in 2010.
Good luck.
Ak