error when trying to refresh data from excel

Hi all,

I have an excel file which is connected to more than one query from an access file.I recently added 3 queries and tried to refresh the data from the excel file, but I am getting the following message :
Couldn't use <filename>; file already in use

Note tha I can refresh all the old queries anf if I try to refresh the new ones I get this message and the same happens in case I refresh the new ones then I try to refresh the old one.

Excel and Access file are located on the same computer. I am using Excel 2010 and Access 2003
Access is linked to tables based on SQL.

When I try to refresh my excel , I make sure that access is not running at all.

You CANT have the excel file open (in Excel) while Access is trying to read it.
Close Excel.

I am refreshing the excel sheet to retrieve data from access queries (access is already closed)

Sounds like the new queries you have created may be accessing your old queries recordset?

For instance, if you have a SELECT query that uses another SELECT query as it's data source.

This isn't something I've come across or tested, but sounds like the only plausible explanation if you do actually have the Access file closed when refreshing Excel data...