This content has been marked as final. Show 1 reply
Well, the main problem is that what you're describing is connecting and running a query, which you need ODBC (or some other connectivity to the database) to do. Without that,the best you can do is run the query once, save the results into Excel, and let other people reopen whatever the results were back when you ran it instead of getting the most recent version.
You can run your query in Excel by hitting Data (assuming you have 2007 or 2010), From Other Sources, ODBC. Connect to the database, and copy your query into the SQ window. Excel will go off and run it.