I'm using Excel 2003 (SP3) and have an MS Query (to a SQL database) which has three parameters (parameters which get their values from a cell reference). The query can be refreshed and edited, but if I try to edit the parameters, Excel crashes.
I use queries all the time and have many workbooks which use queries with parameters which refer to cells. It seems to be that if the cell that the parameter is getting its value from is on the same sheet, it works fine, but if the cell is on a different sheet in the same workbook, it crashes.
I've tried on a machine running Excel 2002 and editing the parameters works fine.
Any ideas?
Bookmarks