How can I make a popup in excel to filter external data ?

[Buzzard7]

I need to make a popup come up when I open an Excel template, to filter external data.

I have templates linked to a SQL server. Some of the tables are larger than 65,536 rows.

I want to be able to specify what to filter before it loads in the Microsoft Query.

 

[Nareik]

If you customise the query to take parameters, you can specify the parameters in excel and then query the external data.

Do this by creating the query in MS Query with the parameters. Then run the query form excel, right click in the returned data and select parameters. You should be able to work it out form there. online help has a brief dicussion on this feature too under 'parameter queries'.