Access query link to Excel not refreshing

[Guest]

I have several queries (all from the same database) that I have linked to
several spreadsheets. I just made a copy of an exsisting query, which is
linked to a spreadsheet, and changed the query criteria so that different
information is selected. When I go to create a link into a spreadsheet
(using the new query) and refresh the link, the only information I get are
the field headings. I don't have this problem with other queries in the same
database. Why am I not getting the link to pull the information from the new
access query? If one would work, you would think all of them would work.

 

[Guest]

If it was working and you changed it and now it is not working, then you need
to review the query and see what went wrong. I would suspect your filtering
criteria is not what you think it is.