tip

Display # 5 10 15 20 25 30 50 100 All

Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook

Written by Kasper de Jonge on 19 March 2010.

Always navigate to the upper left-hand cell (A1) prior to saving the PowerPivot workbook

Written by Dave Wickert on 19 November 2009.

Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder

Written by Denny Lee on 06 January 2010.

Gemini (PowerPivot)- Copy/Paste

Written by T.K. Anand on 14 October 2009.

If you are going to change a server’s static IP address after you have installed SharePoint 2010, please remember to reboot the server to make the new address become recognized. An ‘iisreset’ isn’t good enough

Written by Dave Wickert on 02 December 2009.

If your goal is to show PowerPivot charts to their best effect in the SharePoint PowerPivot Gallery, then Hide those chart data sheets

Written by Russell Christopher on 21 November 2009.

Import Filters in PowerPivot

Written by Robert C. Cain on 24 November 2009.

It’s always a best practice to avoid filtering an entire table if the filter condition involves only some of the table columns (i.e. when no key/unique columns are used in the condition expression).

Written by Marius Dumitru on 25 June 2010.

Make your PowerPivot on SharePoint “view only”

Written by Kasper de Jonge on 04 March 2010.

PowerPivot field list and Excel field list at same time!

Written by Rob Collie on 27 June 2010.

PowerPivot Nuggets

Written by Frederik Vandeputte on 18 August 2011.

PowerPivot Tips and Tricks - First Findings

Written by webadmin on 22 November 2010.

PowerPivot: improve the performances by sorting tables

Written by Alberto Ferrari on 15 April 2011.

Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table?

Written by Vidas Matelis on 24 March 2010.

Q: My PowerPivot table was loaded from the SQL Server table that recently was changed. How can I apply these source table changes to PowerPivot table?

Written by Vidas Matelis on 24 March 2010.

SharePoint has a new high severity health rule for SharePoint 2010 that raises an error if your machines does not have 2X the amount of physical memory in free disk space

Written by Dave Wickert on 04 October 2010.

SharePoint keeps all documents even after they are deleted within the SharePoint content database for up to 30 days. To fully delete SharePoint documents and free up space you need to delete them from 3 places

Written by Denny Lee on 06 January 2010.

Some fields are loaded into PowerPivot, but are not used in the pivot reports. Hide them in the PowerPivot by selecting column and then choosing menu "Hide columns"->"From Pivot table".

Written by Vidas Matelis on 08 November 2009.

The 64-bit versions of Excel and the PowerPivot add-in will support significantly more data than the 32-bit versions. You must use the 64-bit versions if you are importing more than one million rows or columns of data.

Written by Microsoft on 10 November 2009.

Tips and Tricks for Troubleshooting a Microsoft SQL Server PowerPivot for SharePoint Installation

Written by Dave Wickert on 25 June 2010.

• 1
• 2