I have a workbook developed in Excel 2003 that uses a parameterized query. The parameter is linked to a cell on another worksheet and is set to Refresh automatically when the cell value changes. The linked cell contains a dropdown list, but when the user chooses a value, the refresh does not work.
This worked fine in 2003 and still seems to work if the cell referenced is on the same sheet. It is only when the cell used for the parameter is on a different sheet than the query that it is broken. Does anyone know what has changed and why it may no longer work in 2007?
Thanks...