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

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

Answer 1

Answer 2

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

Answer 3

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.