Home
> Uncategorized > PowerPivot: Getting Error While Saving a file to Gallery from Excel
PowerPivot: Getting Error While Saving a file to Gallery from Excel
Issue:
Using Excel 2010 when try to save a file to SharePoint Gallery it fails with error stating:
Excel 2010 –>File –>Save to SharePoint
![clip_image002[7]](https://karangulati.files.wordpress.com/2012/02/clip_image0027.jpg "clip_image002[7]")
Error
Resolution –
When accessing these files from a SharePoint document library, the ACE provider will attempt to connect to the library using a WebDAV client connection, which is not available on Windows Server 2008 and Windows Server 2008 R2 by default. You can install the WebClient service on Windows Server by enabling the Desktop Experience feature set.
How to enable:
http://support.microsoft.com/kb/947036
WebDAV is the protocol that SharePoint uses to make a SharePoint site look like a file share. And unfortunately it is the way that many of the Excel features use for browsing a web site.
Categories: Uncategorized
Karan Gulati (SSAS Maestro) 
Great article! I loved the insight and advice given. Further, your article writing style is very fun to read. If you have time please browse my new blog and tell me what you think.
Great article! I loved the knowledge and the information given . Additionally, your writing style is very fun to read. If you have enough time please check out my brand new website and tell me what you think.
Aw, this was a very nice post. In idea I wish to put in writing like this additionally – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and on no account appear to get something done.