I have a pivot table in an excel 2007 workbook that links to an external data source. The query is along the lines of "exec procedure @param=?" (using an ODBC connection to sql server 2005). I am using a cell reference to provide the value for this parameter. This works fine, but when you save the book and re-open it the reference is lost and if you try to refresh the pivot table (without fixing this) then the application crashes.
Any neat work arounds would be appreciated.