How to avoid alert "You won't be able to undo the changes this action query is about to mak...

Force Excel to keep sheet name when referencing external tables...

How can I compare queried data with input data in excel, and then use that comparison in a condition...

Insert new columns to SQL query data table in Excel...

Using an existing external data connection to create a recordset...

Importing data connection from text (Excel) FAST WAY...

Can't use the OLAP cube using an established external data connection in Excel, but I can create...

Excel macro to change external data query connections - e.g. point from one database to another...

Performance issue running a macro in Excel across two tables from external data sources...

Excel macro to change location of .cub files used by pivot tables? (to allow .xls files that depend ...

Excel SQL External Data Return All Results If Parameter Is Empty...

Append new data to an External Data table in Excel...