SQL Server Developer Center
 
Sign in
United States (English)Drop down arrow
Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中国 (中文)台灣 (中文)日本 (日本語)
 
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 3

Power Pivot announcement

  • Link
    Fix for PowerPivot November CTP Expiration Released
    Kathy MacDonald [MSFT] Wednesday, April 7, 2010 10:07 PM

    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 for Excel 2010 November CTP Expired
    Kathy MacDonald [MSFT] Friday, April 2, 2010 9:18 PM

    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

  • Link
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram Friday, February 5, 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.

RRS feed

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
Power Pivot
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    0 Votes

    Excel With PowerPivot on SharePoint issue

    SQL Server
     > 
    Power Pivot
    Hi, We have Excel files we release to users in SharePoint to edit data. The files use an embedded data model in order to produce a mildly complicated set of pivot tables with ...
    Unanswered | 0 Replies | 29 Views | Created by Gerry Lopez - 3 hours 44 minutes ago
  • large check mark
    0 Votes

    convert T-SQL in DAX - self join table

    SQL Server
     > 
    Power Pivot
    a.date_purchase  where (a.product in ('2', '3', '4') and b.date_purchase='30/03/2018' )  and b.product='4'  and b.date_purchase
    Unanswered | 0 Replies | 70 Views | Created by Silver_75 - 12 hours 23 minutes ago
  • large check mark
    0 Votes

    Actuals Deliveries Vs Expected Deliveries

    SQL Server
     > 
    Power Pivot
    Hello Everyone, I have ETD and ATD in my table, where i have to calculate PO's. ETD = Expected time of ...
    Unanswered | 1 Replies | 203 Views | Created by navad32 - Wednesday, December 4, 2019 1:20 PM | Last reply by Herbert Seidenberg - 20 hours 37 minutes ago
  • large check mark
    2 Votes

    PowerPivot in Excel 2013 constantly dropping and reloading data

    SQL Server
     > 
    Power Pivot
    Our organisation is currently in the process of moving from Office 2010 to 2013 so I've been looking at upgrading some of our existing PowerPivot reports to the new version to ensure a smooth ...
    Answered | 7 Replies | 4588 Views | Created by George-UK - Thursday, May 23, 2013 11:06 AM | Last reply by DRD71 - Wednesday, December 4, 2019 3:23 PM
  • large check mark
    0 Votes

    Pbix File as DataSource

    SQL Server
     > 
    Power Pivot
    i have power bi pro  and i need to use one data source for power bi and ssrs reports  the power bi report builder can connect to power bi as data ...
    Unanswered | 0 Replies | 211 Views | Created by benf99 - Tuesday, December 3, 2019 8:42 AM
  • large check mark
    0 Votes

    Filter question

    SQL Server
     > 
    Power Pivot
    Hello I’ve got a measure written 2 ways, almost exactly the same. The difference is the order in the Filter. ...
    Unanswered | 1 Replies | 211 Views | Created by ryand09 - Monday, December 2, 2019 8:09 PM | Last reply by Darren Gosbell - Tuesday, December 3, 2019 8:40 AM
  • large check mark
    1 Votes

    Do you want to be acknowledged as Microsoft SQL Server? Submit your work to December 2019 competition!

    SQL Server
     > 
    Power Pivot
    What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles ...
    Unanswered | 0 Replies | 404 Views | Created by Times Decides - Sunday, December 1, 2019 7:18 PM
  • large check mark
    1 Votes

    Do you want to be acknowledged as Microsoft Power Pivot Guru? Submit your work to December 2019 competition!

    SQL Server
     > 
    Power Pivot
    What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles ...
    Discussion | 0 Replies | 446 Views | Created by Dave Rendón - Sunday, December 1, 2019 7:04 PM
  • large check mark
    0 Votes

    Table Relationships

    SQL Server
     > 
    Power Pivot
      Continents, Countries and Cities The tables are related as follows … Continents  (1) to Countries (M) on ...
    Answered | 2 Replies | 530 Views | Created by ryand09 - Wednesday, November 27, 2019 7:47 PM | Last reply by ryand09 - Thursday, November 28, 2019 3:01 PM
  • large check mark
    0 Votes

    Referencing a linked table column in a calculated column formula

    SQL Server
     > 
    Power Pivot
    Hi, I have built a data model with two tables and they are connected via a column (PositionID). The first table (T1) is pulling data from a SQL Server and the ...
    Answered | 1 Replies | 350 Views | Created by Nico Mohan - Wednesday, November 27, 2019 8:41 PM | Last reply by Aleksei Zhigulin - Thursday, November 28, 2019 10:32 AM
  • large check mark
    0 Votes

    New Queries Won't Load, Existing Will Refresh

    SQL Server
     > 
    Power Pivot
    When trying to load a new query from an SQL database, it just loads all lines but continues to just spin and not ever load the query or refresh.  Existing queries that are both small and very ...
    Unanswered | 0 Replies | 395 Views | Created by ITMikeZ - Tuesday, November 19, 2019 8:09 PM
  • large check mark
    0 Votes

    rounded values from query in power pivot

    SQL Server
     > 
    Power Pivot
    Hello, I have a issue with power pivot. I have connected power pivot to postgres DB via ODBC driver and retrieving data using queries. From recently returned values in power pivot ...
    Unanswered | 0 Replies | 383 Views | Created by aggiato - Tuesday, November 19, 2019 9:00 AM
  • large check mark
    0 Votes

    Incorrect result when working with Max Date

    SQL Server
     > 
    Power Pivot
    I need some help as I get an incorrect result and I can not solve it. I have a table with following fields: - Ordertype ("Actual" or ...
    Unanswered | 1 Replies | 410 Views | Created by JanLöfgren - Monday, November 18, 2019 7:56 AM | Last reply by JanLöfgren - Tuesday, November 19, 2019 6:36 AM
  • large check mark
    0 Votes

    Slow model / pivot table refresh using ALL and ALLEXCEPT

    SQL Server
     > 
    Power Pivot
    Hi all Is there a known issue of when using multiple ALL and ALLEXCEPT in a single PowerPivot model measure that significantly slows down the time it takes to refresh model and ...
    Unanswered | 1 Replies | 451 Views | Created by Simon_Johnson - Friday, November 8, 2019 4:17 PM | Last reply by - M Rivers - Tuesday, November 12, 2019 7:04 AM
  • large check mark
    0 Votes

    Cannot Convert Value to Text

    SQL Server
     > 
    Power Pivot
    I an new to Power Query and am trying to manipulate a data set to roll all of the information in the table below up into a single ...
    Answered | 4 Replies | 822 Views | Created by henningt1979 - Monday, November 4, 2019 5:32 PM | Last reply by henningt1979 - Thursday, November 7, 2019 7:37 PM
  • large check mark
    0 Votes

    dax for a where in clause with subqueries

    SQL Server
     > 
    Power Pivot
    (select min(j) from SameTable where b = [value from filter context]) and b = '' Note SameTable is the same table I'm using for the dax ...
    Unanswered | 0 Replies | 540 Views | Created by ffitzpatrick47 - Wednesday, November 6, 2019 2:09 AM
  • large check mark
    1 Votes

    PowerPivot Excel 2016 - An issue with the Data Model is preventing Microsoft Excel from opening this workbook. Try restarting Microsoft Excel

    SQL Server
     > 
    Power Pivot
    Hi - I have developed my data model in Excel 2013 and now i am upgraded to excel 2016 and eveytime I try open my Data model from Power Pivot Manage I get this error"An issue ...
    Answered | 4 Replies | 15211 Views | Created by Ruch2307 - Friday, March 10, 2017 12:41 AM | Last reply by Kee Chor - Monday, November 4, 2019 6:20 AM
  • large check mark
    1 Votes

    Do you want to be acknowledged as Microsoft Power Pivot Guru? Submit your work to November 2019 competition!

    SQL Server
     > 
    Power Pivot
    What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
    Discussion | 0 Replies | 609 Views | Created by George Chrysovaladis Grammatikos - Friday, November 1, 2019 8:48 AM
  • large check mark
    2 Votes

    Power Query - Cannot Convert Value to Text

    SQL Server
     > 
    Power Pivot
    NOTE THAT IT IS GIVING ME THE FOLLOWING MESSAGE SO I CANNOT ATTACH SCREENSHOTS:   Body text cannot contain images or links until we are able ...
    Answered | 3 Replies | 511 Views | Created by henningt1979 - Thursday, October 31, 2019 2:45 PM | Last reply by Aleksei Zhigulin - Friday, November 1, 2019 8:27 AM
  • large check mark
    0 Votes

    Verify

    SQL Server
     > 
    Power Pivot
    I am trying to complete a post, however, it will not make sense without any images of the spreadsheet.  I keep getting the following error which is preventing me from including the ...
    Answered | 1 Replies | 608 Views | Created by henningt1979 - Thursday, October 31, 2019 7:45 PM | Last reply by chilberto - Thursday, October 31, 2019 9:08 PM
  • Items 1 to 20 of 5600 Next ›
Announcement: 3

Power Pivot announcement

  • Link
    Fix for PowerPivot November CTP Expiration Released
    Kathy MacDonald [MSFT] Wednesday, April 7, 2010 10:07 PM

    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 for Excel 2010 November CTP Expired
    Kathy MacDonald [MSFT] Friday, April 2, 2010 9:18 PM

    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

  • Link
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram Friday, February 5, 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.

 
© 2019 Microsoft. All rights reserved.
Terms of Use|Trademarks|Privacy Statement|Site Feedback