locked
unable to get Calculation Area,Advanced tab and Diagram View options in toolbar RRS feed

  • Question

  • hi every one,

    i am new to power pivot i need help for you,

    i am not getting Calculation Area,Advanced tab and Diagram View option in tool bar,how can access those options.

    if any one know please help me.

    Thanks in Advance.


    srikanth


    • Edited by sunny0817 Monday, May 21, 2012 1:24 PM
    Monday, May 21, 2012 12:55 PM

Answers

  • Hello sunny0817,

    Advanced Tab is the new feature in PowerPivot 2.0, Please make sure you have installed the lastest add-in for your Excel. For more information, please see:
    Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010: http://www.microsoft.com/en-us/download/details.aspx?id=29074

    Regards,
    Bin Long


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Wednesday, May 30, 2012 1:19 AM
    Monday, May 28, 2012 6:15 AM

All replies


    • Proposed as answer by irusul Monday, May 21, 2012 5:59 PM
    Monday, May 21, 2012 5:58 PM
  • Hello sunny0817,

    Advanced Tab is the new feature in PowerPivot 2.0, Please make sure you have installed the lastest add-in for your Excel. For more information, please see:
    Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010: http://www.microsoft.com/en-us/download/details.aspx?id=29074

    Regards,
    Bin Long


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Wednesday, May 30, 2012 1:19 AM
    Monday, May 28, 2012 6:15 AM
  • Hello,

    I've downloaded the latest version of PowerPivot as per the link and I still can't see the advanced tab? Is there something I'm missing?

    Thanks.

    Thursday, June 21, 2012 9:50 AM
  • Hello,

    I've downloaded the latest version of PowerPivot as per the link and I still can't see the advanced tab? Is there something I'm missing?

    Thanks.

    Hi missmeb... i've got the same situation as you... I have downloaded the latest version and I can't see the "Diagram View" button.  Have you solved this problem?  How did you do it?

    By the way, I haven't the Option "Switch to Advance Mode"?

    Thks in advance...  :)

    Wednesday, August 21, 2013 12:15 PM
  • Go to the PowerPivot ribbon tab on the Excel side, click the "Settings" button and let us know what version you see.

    Thanks,
    -Ron

    Wednesday, August 21, 2013 3:38 PM
  • Hi,

    I have Excel 2010, PowerPivot version 10.50.2500.0, and I haven't go access to the Advanced Mode. Do I need a newer version?

    Thanks

    Tuesday, August 27, 2013 8:00 AM
  • I have version 10.50.4000.0

    and I too cannot see the advanced mode or diagram view

    What do I need to do?

    thanks

    Friday, September 13, 2013 4:41 AM