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]

Error

clip_image002

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.

Advertisements
Categories: Uncategorized
  1. March 19, 2012 at 12:31 am

    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.

  2. March 26, 2012 at 12:32 am

    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.

  3. March 28, 2012 at 12:20 pm

    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.

  1. No trackbacks yet.

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

%d bloggers like this: