SQL Server PowerPivot for Excel
Discussions relating to importing data, building relationships, and using DAX within the PowerPivot window.
公告
- 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
篩選及排序使用這些選項可縮小討論清單。
- 1101

Querying data from an Excel source using SQL
BenzaneMicrosoft Employee2013年5月17日 下午 07:03 - 162

Drill trhough like that of Pivot Table on SSAS Cube?
EricLeBouffon 2013年5月17日 下午 01:28 - 2117

lastnonblank in DAX
the_txeriff 2013年5月14日 下午 02:55 - 1105

Powerpivot 2010 not displaying advanced option and new measure
Ghees Alias T 2013年5月14日 上午 06:08 - 065

Connecting to MySQL 3.5.1 database - not able to import data
SonalJ 2013年5月17日 上午 02:16 - 5227

Tree data filter - PowerPivot 2.0
pscorca 2013年5月6日 下午 03:05 - 185

importing SQL 'date' type into pivot tables does not sort as date but as text
Radu Seserman 2013年5月15日 下午 09:19 - 287

Moving average calculation in power pivot
Balaji raju 2013年5月15日 上午 11:57 - 1160

Avoid Blanks in PowerPivot
Grace Bite 2013年5月14日 上午 12:23 - 5363

Date filtering with sparse table, getting most recent column value
Henry Gabryjelski - MSFTMicrosoft Employee2013年4月18日 上午 07:33 - 071

Move & Copy option not present for Power View sheets in Excel 2013
reachnasir 2013年5月16日 上午 06:58 - 497

Last Order Date; DAX ; PowerPivot
Matthaeus W 2013年5月15日 下午 07:22 - 285

Duplicate slicers with the same connections
Zero2ThreeSixty 2013年5月15日 下午 01:49 - 072

PowerPivot Report doesn't work in SharePoint because of Microsoft Access data source?
Silver_A 2013年5月15日 下午 11:49 - 187

PowerPivot for Excel 2013, call execute stored procedure with parameters
rv7a99cv 2013年5月15日 下午 04:44 - 35144

Combine data from multiple Measures results in a Crossjoin in pivot table
chenthorn 2011年6月5日 下午 07:59 - 075

Filters in Excel 2007 is not working
sudipta.2.ghosh 2013年5月15日 下午 01:48 - 175

Power Pivot Excel Plugin download link doesnt work
AmolRajmane 2013年5月15日 上午 11:56 - 0100

A Sharepoint Stored Excel as a PowerPivot Data Source
Jon Larkin 2013年5月14日 下午 09:14 - 2637459

Install Issues for PowerPivot for Excel? Read This!
AshviniSharma [MSFT] 2009年11月25日 上午 05:28

