Microsoft Developer Network > Página principal de foros > SharePoint - Excel Services > Creating a Data Connection between an Excel workbook and an Excel Data Source
Formular una preguntaFormular una pregunta
 

PreguntaCreating a Data Connection between an Excel workbook and an Excel Data Source

  • martes, 30 de junio de 2009 14:38nigoki Medallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuario
     
    Hello,

    I'm new to WSS and Excel Services and I'm having a hard time trying to solve this:
    I'm trying to connect an excel workbook with an excel data source, but I can't see a way to create a Data Connection that uses an .xlsx file as a data source remotely.  I tried to use ODBC DSN but it seems to use files stored just locally or in my network.
    I created a DCL and the libraries that hold the workbooks and the data sources.

    Well, what I really want to do is to link one excel to another in the Sharepoint, so when one cell of these .xlsx files is changed, the other will be able to catch the value of this cell updated and use some formulas, is there a way to do that?

    I appreciate any help you guys can give me. Thanks.