Open Excel refresh - locked State (1 Viewer)

[Jayce72]

I have a database (sql server back end - access front end)

I use vba to open an excel sheet that is already linked to a query in the current DB, when I try to refresh, I get a DB is in a locked state by Admin etc

Is there a way to refresh this sheet with passing the data to another DB.

Granted - I might need to post this on an excel forum - but it's a cross cutting query (pardon the pun)

 

[Ranman256]

are you trying to refresh a linked Excel sheet?
you cannot have it open and refresh too.

 

[Jayce72]

are you trying to refresh a linked Excel sheet?
you cannot have it open and refresh too.

I am. Just wondering if I was doing something wrong or if it was impossible. Unless anyone can suggest a work round