PowerPivot Tips
Filter     Display # 
# Article Title Author
1 Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint Dave Wickert
2 When you want to import different query’s from the same datasource reuse the same data source connection by selecting it from existing connection list Kasper de Jonge
3 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 Denny Lee
4 Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder Denny Lee
5 To regenerate thumbnail in the PowerPivot gallery change on of the files property (example: Title) and save that change. Dave Wickert
6 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 Dave Wickert
7 If your goal is to show PowerPivot charts to their best effect in the SharePoint PowerPivot Gallery, then Hide those chart data sheets Russell Christopher
8 Use a fixed port# (for example 55000) for SharePoint Central Admin Dave Wickert
9 Always navigate to the upper left-hand cell (A1) prior to saving the PowerPivot workbook Dave Wickert
10 You cannot add new rows into a PowerPivot table, You can only add new columns of data. Microsoft
 
<< Start < Prev 1 2 Next > End >>
Page 1 of 2