For the best file upload performance and features, use the SharePoint built-in file upload capabilities. It is easy to do, just click on “Add file” on your document library and the file upload dialog box appears. Enter the local path to the file and away you go:
Note: The second dialog box that pops up is optional, the file has already been uploaded, but if you’d like to provide a title and other information about the file you can do so here. But if you hit cancel, all is OK; the file is still there.
So from a geek’s perspective, a reasonable questions is: why is this best? There are several reasons. First and most importantly, none of that Excel desktop stuff is in the way. The stability and reliability of the Office Sync Center has been a sore point all throughout the Office 2010 beta cycle. However, it is also a lot faster because you don’t have the WebDAV overhead involved; nor are their additional protocols on the wire. It is a pure http PUT that is being used. Quick and reliable. It is the way to go.
thanks for your post. Besides that, i would point out another benifit. when publishing PP from Excel on Win2008 Server, it requires to install Desktop Experience feature, otherwise, it doesn’t work. though few people will use Office on server machine, but it does add some additional job to do.
[...] we have to save the App to SharePoint, thanks to Dave Wickert we know manual uploading to SharePoint is the best way to go, resulting in a published PowerPivot [...]