Excel linked to Access
 

Hi

After displaying the results of an Access query on an
excel worksheet (as a linked excel object), I have moved
both the Access DB and Excel worksheet to another
location. The problem now is that I cannot seem to update
the data on excel. I have tried to change the source in
Edit Links in excel but I receive the following
error: "Reference is not valid . Reference must be to an
open worksheet" I am a little puzzled since I have the
worksheet already open.

Many thanks for your assistance.
Dean Collins