PowerPivot Tips
Filter     Display # 
# Article Title Author
1 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). Marius Dumitru
2 You can hide a table in the PowerPivot field list by marking ALL its fields as "Hide in Pivot". Dave Wickert
3 You must use a 32-bit browser when running on a 64-bit client. Virtually every SharePoint feature and application, e.g. Excel, PPT, and Word Web Apps, do not support 64-bit browsers Dave Wickert
4 You can allow non-administrator users to log on to your domain controller through remote desktop by changing windows GPO permissions Dave Wickert
5 Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint Dave Wickert
6 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
7 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
8 Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder Denny Lee
9 To regenerate thumbnail in the PowerPivot gallery change on of the files property (example: Title) and save that change. Dave Wickert
10 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
 
<< Start < Prev 1 2 Next > End >>
Page 1 of 2