SQL Server PowerPivot for Excel
Discussions relating to importing data, building relationships, and using DAX within the PowerPivot window.
Announcements
Fix for PowerPivot November CTP Expiration Released
Kathy MacDonald [MSFT]Microsoft EmployeeWednesday, April 07, 2010 10:07 PMThe PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
Vikram JayaramMicrosoft EmployeeFriday, February 05, 2010 9:16 PM
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================
The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
The solution is to upgrade the beta components to their released versions when they become available.
PowerPivot for Excel 2010 November CTP Expired
Kathy MacDonald [MSFT]Microsoft EmployeeFriday, April 02, 2010 9:18 PMIf you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services
Filtering and SortingUse these options to narrow down the question and discussion list.
- 35812

How to ask a question efficiently in TechNet forum
Challen Fu Wednesday, October 26, 2011 8:16 AM - 117

can we get the data immported into a PowerPivot and load it into a normal worksheet
vikramjhurry 6 hours 19 minutes ago - 131

Unable to connect to the Vertipaq Engine
barnettjacob 14 hours 50 minutes ago - 013

Lack of choice of parameter values from a cell in Microsoft Query.
ROSSIJANIN 7 hours 52 minutes ago - 032

Relationship May be Needed message - when I've already created a relationship
Henry Winkler IV 16 hours 3 minutes ago - 1339

How to display chart and slicers only of Excel Sheet generated by Power Pivot.
Amol.Amol Monday, May 14, 2012 12:28 PM - 051

Quantity of a product on last date on columns
san463 Monday, May 21, 2012 11:10 PM - 9477

PowerPivot Data Structure Question
Sql Dude Sunday, May 13, 2012 9:01 PM - 173

unable to get Calculation Area,Advanced tab and Diagram View options in toolbar
sunny0817 Monday, May 21, 2012 12:55 PM - 7667

Calculating a measure between two filtered dates
pscorca Friday, April 27, 2012 12:09 PM - 3176

Should PowerPivot Be This Slow / Require This Much Memory
Christopher-Boston Friday, May 18, 2012 3:11 PM - 2153

Can't install PowerPivot 2012 RTM on 64-bit machine running 32-bit Office
Charley KydMVPSunday, May 20, 2012 6:33 AM - 1191

Powerpivot with stored procedure
AndrewSkerrett Saturday, May 19, 2012 5:20 AM - 1231

Change Data Source to a different one without modifying the Pivot tables.
Aamir ZiaMicrosoft EmployeeThursday, May 17, 2012 6:07 PM - 1164

PowerPivot-how to sum value with certain label
axepert Friday, May 18, 2012 7:14 AM - 1266

How to combine Slicers and Chart?
Amol.Amol Wednesday, May 16, 2012 6:42 AM - 1280

How to import tables from different sql servers in the same table?
Lucas lucas lucas Wednesday, May 16, 2012 6:24 PM - 3316

Out of Memory when trying to delete columns or worksheet in PowerPivot
Josh Ash Monday, May 14, 2012 11:56 PM - 0207

Erro SSAS 2012
TheAkaBroken Wednesday, May 16, 2012 5:51 PM - 2390

DAX Date functions
sqldba_123 Sunday, May 13, 2012 10:05 AM

