I created an Excel file that queries an Access database that is
password protected. The
file has multiple pivot tables that have SQL connection to the
database.

When I try to refresh these pivot tables I get a dialog box asking me
to provide authorization to the data
source (Login name is supplied, password is not). If I were the only
user I would consider this an unfortunate inconvenience, but I created
this Excel file to allow other users to access data in specific tables
and not have access to the whole database. Excel asking for a
password pretty much kills the purpose of the file.

Is there an elegant way to put this password into the Connection?

Terry