Help!! In Excel 2003, I could create queries using ODBC - point to the database, and save/export those queries back into Excel. I could later a) select the query from within Excel by going to Data/Import External Data/Import Data, select the query, click open, and then the Import Data pop up that asks you where you want to put the data on the bottom had a button you could click at that point to say Edit Query. It would then open up your editor (I used MSQuery), you could change fields or add/delete tables and when done, you could save it as a new query and import it back into Excel.

OR - better yet, b) you could run the query (or open up a previously exported query report) then right click on any cell and edit query which would pop up the MSQuery. Quick. Simple.

All I can find to do in Excel 2007 is "refresh." Well that's lovely, but where, oh kind friends, is the place I need to click or set to EDIT existing queries or reports previously run off those queries? Right click doesn't give me edit, neither does running an existing one. I do not wish to recreate the wheel every time I want to run the same report but for one or two different parameters. Some of them took me a while to create.