Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI

When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file.  This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the file than the Office Upload Center.  The Office Upload Center is included as part of Office 2010 and what is great about this feature is that you can save the file asynchronously.  What this means is that you can save the file and then continue…

Rate this:

Quick Tips for clearing up space #PowerPivot for SharePoint Uploading

When you upload your PowerPivot for Excel workbook to your PowerPivot enabled SharePoint site, you typically will deal with much larger files than your other SharePoint sites.  This is the reason why we suggest that you increase the Excel Services and SharePoint to the max file sizes allowed (to do this, follow Step 18 at http://powerpivotgeek.com/server-installation/existing-farm-install/).   Saying this, there are some other quick tips as well: The SharePoint Server local cache is the c:\windows\temp\WebTempDir.  This folder can fill up real fast so you may want to clear out this folder every so often and/or aim the local cache to…

Rate this:

More great PowerPivot resources!

As you already may know, we have a couple of forums for PowerPivot at: SQL Server 2008 R2 PowerPivot for Excel SQL Server 2008 R2 PowerPivot for SharePoint Dave Wickert with his PowerPivotGeek.com site has also created two new sections: Reported Problems section which compiles the different issues concerning PowerPivot for SharePoint installations and Troubleshooting section which complies different Troubleshooting issues concerning PowerPivot for SharePoint installations. Please do not forget that the all four PowerPivot for SharePoint installation guides can be found here as well.   Rob Collie has also put together: The Great PowerPivot FAQ where you can see…

Rate this: