Why PowerPivot add-in is missing from some Office 365 plan?

When you follow the steps in my previous post "How to: Enable PowerPivot Add-ins for Excel 2013" to add PowerPivot in excel with Office 365, you may not be able to find PowerPivot in available COM add-ins.

You may wonder whether you missed any steps? That may not be the case. From "Feature availability across Office 365 plans", you will know PowerPivot feature is only available for the following Office 365 Plans (as of 11/2017):

• Office Professional Plus 2013         
• Office Professional Plus 2016
• Office 365 ProPlus                     
• Office 365 Business
• Office 365 Business Premium
• Office 365 Enterprise E3

So go ahead to check your Office 365 Plan first. If it is not available, the alternative is to use Power BI Desktop, the tool for desktop data analytics. Good luck!

How to: Show Line Number in SQL Server Management Studio

Have you ever met the following scenarios: 1) when you write a very complex ad-hoc query in SQL Server Management Studio (SSMS), you need to count the total columns that have been derived. 2) You even need to refer to the line that appears in the error message. If yes, you need to enable the option of showing line numbers in SSMS. In fact it is very simple. It can be done in a minute. You just need to know to click the right button. Be cautious that it is different for SQL Server 2008 (2008R2) and SQL Server 2012.

Solution

Step 1: In SSMS, select Tools tab then Options as shown below

Step 2: In Option Popup Windows, expand “Text Editor”

a. For SQL Server 2008 and SQL Server 2008R2, you need to choose “All Languages”. Under General page, check the box for Line Number.

b. For SQL Server 2012, you need to choose “Transact-SQL”. Under General page, check the box for Line Number.

Hope this tip will help you improve your coding efficiency. If you just want to jump to some specific line in SSMS quickly, you can use CTRL+G hot key.

How to: Remove Table Format from Microsoft Excel 2013

When we work with PivotTables, sometimes we don’t want a spreadsheet to be a table any more. How to remove table format from it and convert it to a normal range? Below will show the way to achieve it in Excel 2013.

Step 1: Remove any table style

Select any cell in your targeted table till Design Tab appears under TABLE TOOLS. Choose the clear style as shown:

Step 2: Convert to a normal range

After converting a table to a normal range, you can delete the table without deleting represented data.