I have a sheet which uses a data connection to obtain data for a pivot table from an external database using a SQL query. The user can set parameters for the SQL by completing a few cells in the worksheet. The process is described here.
When I save and reload the file and refresh the data Excel crashes. I have found that the contents of the 'Get the value from the following cell:' field from the Parameters dialog box are not saved.
I have tried Excel 2007 and Excel 2010, saving in both XLSX and Binary formats but none of them save the setting. Does anyone have a fix or a workaround?
Screenshot of the dialog box is here: