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 to work with your Excel file in the mean time.  With the SharePoint UI, once you upload the file it is locked and you cannot work with the file until the upload has been completed.  Though, based on current sets of tests, the upload via SharePoint UI is faster than the upload via Office Sync Center so there is the balance between whether you want to work with the file asynchronously or do you want to have faster upload. 

To perform an Excel “Save As”, you need only to click on “Save As” within the File option of the Office Ribbon and specify the PowerPivot Gallery of your SharePoint site.

 Read more…


0 Responses to “Uploading #PowerPivot for Excel workbook using “Save As” vs. SharePoint UI”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)


Copyright © 2010 Denny G Lee - All Rights Reserved

%d bloggers like this: