Persistant SQL2005 connection to Excel Spreadsheet

By suzanne.l.healy ·
Hi All,

I have an Excel 2007 spreadsheet that I used to create a Pivot table to summarize and report on data from a SQL2005 database file.

I need for any user with access to this spreadsheet to be able to open it and run the pivot table report.

What is happening is that if a user on another workstation opens the file, they aren't able to pull from the database, because it's looking for a locally defined connection.

Can anyone point me in the right direction to have the spreadsheet automatically point to the database file, regardless of who opens it on what machine?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums