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.

image

Figure 1: Excel “Save As” functionality

When you do, you’ll notice the Office Upload Center icon pop up in the notification area.

image

Figure 2: Microsoft Office Upload Center within the Notification area

If you open the Office Upload Center, it will provide a dialog of all of the files that it has pending upload or recently uploaded.

image

Figure 3: List of files being uploaded (notice Pending Uploads) to the SharePoint site.

When it works great, well, it works great!  In order for the Office Upload Center to perform its tasks, it will create a copy of the file in its cache and then upload the cached version of the file to SharePoint (hence allowing you to work with the original file in the meantime).   Notice how on Figure 4 that there is a large file that is curiously the same size as my original Excel file.

image

Figure 4: Office Upload Center Cache location

There are times where there are errors with the upload with the Office Upload Center.  If they do, they should show up in the Pending Uploads section of the Office Upload Center.   From here, you click on “Actions” (notice the Actions button in Figure 3) which should allow you to delete it.

If for some reason you cannot delete it, then what you can do is:

  1. Kill the Office Upload Center process within task manager (MSOSYNC.exe)
  2. Go to the C:\Users\<user>\AppData\Local\Microsoft\Office\14.0 location.  Often if there are issue with uploading through this method, you can delete the files in this directory.You may also want to delete the files in the
    1. C:\Users\<user>\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO
    2. C:\Windows\ServiceProfiles\LocalService\AppData\Local\Temp\TfsStore\Tfs_DAV

Ensure that you have the original files still stored somewhere else before deleting these files but this should clear out the cache and you can then re-start the upload all over again.

For Quick Tips for clearing up space #PowerPivot for SharePoint Uploading, please refer to the linked blog posting.  Note that the reason a PowerPivot for Excel workbook may fail to upload via the SharePoint UI is that you’ll need to clear out the files within SharePoint (as per the blog posting).

Enjoy!

7 thoughts on “Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI

  1. Pingback: Uploading #PowerPivot for Excel workbook using “Save As” vs. SharePoint UI « PowerPivot Twins!

  2. Pingback: Dude, Where’s my PowerPivot workbook? « Denny Lee

  3. Hi Denny,

    Any ideas on this error… when trying to save a Powerpivot workbook to the PowerPivot Gallery directly from Excel.. we enter “http://SERVERNAME/PowerPivot Gallery” in the address bar and it says “You cant open this location using this program”

    • My guess is that you may need to do the “Save to SharePoint” mode. Or if you’re using a server OS like WS2008, you’ll need to turn on Desktop Experience. Are you still able to upload directly to SharePoint from the UI?

  4. Unfortunately I already tried both! We are on Server 2008 r2. Other ideas? I’ve scoured the web with no luck.

    • There are a number of reasons where the document upload center says failed: sign in – can you please verify that you have installed Desktop Experience and can log into the noted SharePoint document library?

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s