I did forget one thing in the previous message. If you use Method Two (VBA
Code), when finished, you will need to delete the new, empty worksheet that
you created in the workbook. This will get rid of the temporary code (which
is attached to that new empty worksheet) and prevent an all-new annoyance on
opening the workbook, the 'Macros Dissabled' security message.

"Vernon" wrote:

The access database my excel workbook is trying to link to no longer exists.
Yet each time I open the lworkbook I receive a message to enable or disable
automatic refresh. How do I unlink and how do I shut off the prompting for
refresh?