Persistant SQL2005 connection to Excel Spreadsheet

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?

Thanks