Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [office-data-connection]

Is a predefined file format for storing connection strings and credentials against a remote data source typically a database.This file is used with MS Office applications like Excel and SharePoint Server for remote data access.

2
votes
0answers
71 views

Why does the Manage PowerPivot Data Refresh page show a data source that is not in the workbook being configured?

I have several Excel workbooks hosted on an on-premises SharePoint installation that are refreshed each day. Each workbook accesses one of our Analysis Services cubes via Excel Services. When I went ...
4
votes
1answer
5k views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
1
vote
1answer
1k views

Infopath Data Connections not site relative

First of all, let me start off by saying the following about SharePoint 2010 and Infopath forms. Great idea, VERY Poorly implemented and documented by MS. For a developer to develop and deploy is a ...