SQL Server PowerPivot for Excel
Discussions relating to importing data, building relationships, and using DAX within the PowerPivot window.
Announcements
- Link
Fix for PowerPivot November CTP Expiration Released
The 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.
- Link
PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
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.
- Link
PowerPivot for Excel 2010 November CTP Expired
If 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.
- 3120902

PowerPivot and query parameters
XASD Thursday, November 19, 2009 6:52 AM - 275363

How to Show all Columns for a DataSet When No Data Exists for That Row/Column Intersection
Whalensdad Tuesday, January 31, 2012 3:38 PM - 2637786

Install Issues for PowerPivot for Excel? Read This!
AshviniSharma [MSFT] Wednesday, November 25, 2009 5:28 AM - 247275

Error while opening the power pivot (xlsx) file
Nitesh Rai Friday, April 09, 2010 6:32 AM - 246659

Are OLEDB data types restricted in PowePivot?
ndee Friday, May 07, 2010 2:04 PM - 2410298

Power Pivot Beta Software Has Expired
Breadon Hill Thursday, April 01, 2010 9:15 AM - 233611

Help with measure for first Real project
sr750 Wednesday, April 25, 2012 5:30 PM - 239888

PowerPivot for Excel - Import pipe-delimited file?
Tim MitchellMVPMonday, February 22, 2010 8:18 PM - 23977

Compute distinct sessions conducted from new clients only
Ashish MathurMVPWednesday, February 27, 2013 2:05 AM - 228867

Unable to use PowerPivot with Office Beta
alwaysneedhelp Thursday, November 19, 2009 5:35 PM - 223705

Powerpivot - Can't insert formula that combines two or more different columns and keep getting message "unhandled exception has occurred in a component in your application...
ALEXRK Wednesday, August 29, 2012 12:36 AM - 226499

Power Pivot Data source
krishna_ece Thursday, February 02, 2012 6:47 PM - 205107

Problems with Relationships in 2 tables (originally excel files).....
Chris McElrath Thursday, March 29, 2012 9:10 PM - 2015850

Powerpivot and Stored Procedure as a SQL Source
bittyboy Thursday, March 18, 2010 9:13 PM - 2011684

How to get PowerPivot on the web
exAHSacto Tuesday, September 27, 2011 2:16 PM - 201150

dateadd() per week
the_txeriff Thursday, November 08, 2012 10:12 AM - 183733

PowerPivot relationships issues
MAQ1 Thursday, April 12, 2012 5:42 PM - 185743

comparing current row with previous row
guudfella Tuesday, December 14, 2010 1:43 PM - 184150

Count of Sales Orders
SDTCPA Friday, January 20, 2012 3:46 PM - 171064

Powerpivot Contiguous Date ERROR
John Newbie604 Wednesday, January 09, 2013 12:05 AM

