I designed a workbook that gets external data from an Access database using
Microsoft Query. It works great. My issue is I need to save the workbook
and email it to an end user who should not have any interest in the Access
database. Accordingly, when the user opens the workbook there should be no
linkages to the embedded Microsoft Query and no prompts should pop-up (ex:
"enable" or "disable" query refresh.) How can I save the workbook such that
all evidence of Microsoft Query is hidden / invisible to the end user?

hi,
Save the file then save the file with a different name say
same name but with a date. in the Name/date file click
dataget external datadata range properties.
uncheck Save Query Definition. this will remove the query
from the name/date file. email the name/date file.


-----Original Message-----
I designed a workbook that gets external data from an
Access database using
Microsoft Query. It works great. My issue is I need to
save the workbook
and email it to an end user who should not have any
interest in the Access
database. Accordingly, when the user opens the workbook
there should be no
linkages to the embedded Microsoft Query and no prompts
should pop-up (ex:
"enable" or "disable" query refresh.) How can I save the
workbook such that
all evidence of Microsoft Query is hidden / invisible to
the end user?
.