<div>
If all the reports are accessing the same database, then you should be able to set up one ODBC DSN that all the reports can connect to the database with.
</div>


If all the reports are accessing the same database, then you should be able to set up one ODBC DSN that all the reports can connect to the database with.

<div>
Excel seems to require the password for the account we're using for reporting in every file that uses the connection. &nbsp;Is this right?
</div>


Excel seems to require the password for the account we're using for reporting in every file that uses the connection.  Is this right?

<div>
<div class="content wysiwyg-content">
We are converting about 300 reports from SSRS to Excel. &nbsp;Is there a concept in Excel that equates to the SSRS shared data sources? &nbsp; <br />
<br />
It seems we need to define a new data connection for each report and stored procedure.<br />
<br />
Is it possible to have 1 data connection (with the data base and userid/password defined) and share it with all the reports that use stored procedures from the database so all the excel report needs is the stored procedure name?
</div>
</div>


We are converting about 300 reports from SSRS to Excel.  Is there a concept in Excel that equates to the SSRS shared data sources?   

It seems we need to define a new data connection for each report and stored procedure.

Is it possible to have 1 data connection (with the data base and userid/password defined) and share it with all the reports that use stored procedures from the database so all the excel report needs is the stored procedure name?

How to create a generic data source connection for Excel to use SQL Server stored procedures?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.