Howdy,

I have a workbook with one pivot table created from an
Access DB. I would like to share the workbook, but find
that other users have to navigate to the database in order
to refresh data. I thought the issue was around the query
file, and have written VBA code to look for the query file
in the "C:\Documents and Settings\username\Application
Data\Microsoft\Queries\Query_name.dqy" and put a copy there
is one does not exist; but that does not seem to address
the issue. In fact, if I refresh the data on another users
computer and navigate to the database (which maps the
drive), the query file is not apparantly needed.

I would rather point to the \\server\path versus having
manually point to the file and mapping the drive. What
would the VBA code look like to accomplish this?

What is the purpose of the query file?

TIA
regards,
Tim