Selected Tags:

tip
Available Tags: connection, excel, load, setup, sharepoint
Title Author Date
Gemini (PowerPivot)- Copy/Paste T.K. Anand 10/14/2009
To reduce memory consumption load into PowerPivot just fields that will be used by Pivot table reports or by PowerPivot joins/calculations. Vidas Matelis 11/08/2009
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". Vidas Matelis 11/08/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. Microsoft 11/10/2009
You should consider learning Data Analysis Expressions (DAX) language. Using DAX is necessary if you want to build relational queries or custom data manipulation in the PowerPivot data you assemble in the workbook. Microsoft 11/10/2009
When creating data connection, specify data or file locations in a format that is accessible over a network connection. An HTTP URL or a shared folder (such as \\srvName\ShareName\FileName) are examples of locations that can be accessed from either a clie Microsoft 11/10/2009
You cannot add new rows into a PowerPivot table, You can only add new columns of data. Microsoft 11/10/2009
Always navigate to the upper left-hand cell (A1) prior to saving the PowerPivot workbook Dave Wickert 11/19/2009
Use a fixed port# (for example 55000) for SharePoint Central Admin Dave Wickert 11/20/2009
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 11/21/2009
Import Filters in PowerPivot Robert C. Cain 11/24/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 Dave Wickert 12/02/2009
To regenerate thumbnail in the PowerPivot gallery change on of the files property (example: Title) and save that change. Dave Wickert 12/11/2009
Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder Denny Lee 01/06/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 Denny Lee 01/06/2010
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 01/10/2010
Make your PowerPivot on SharePoint “view only” Kasper de Jonge 03/04/2010
Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint Dave Wickert 03/06/2010