Access query link to Excel not refreshing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing Data Daily From a Linked Excel Spreadsheet 2
Auto refresh linked excel table from access database 1
excel/access link 2
Access Form Refresh 1
Data not showing from Linked Excel 3
Link Excel 2003 to Access 2003 Not Working For Me 1
Auto Refresh Query Table 4
Link query to Excel, then back to Access?? 1

Back
Top