Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Thanks

share|improve this question
    
The work around I've used is to effectively put the value I was using (from the cell reference) into a table in the database (a parameters table). It's not brilliant but its worked for me in this case. The procedure now takes an optional parameter and if the parameter is not supplied then it uses the value in the database table. –  user664210 Aug 1 '12 at 12:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.