I have an .xlsm file with a saved query definition to refresh external text
data when opened. I'm trying to get an auto_open macro to remove
duplicates. The macro is running before the refresh. Is there a way to
have it run after the refresh and where is the saved query?
Thanks,
Ed