MS Access Query not visible from Excel

My guess is that your excel file is pointing to a different copy of the access file.

You could check your Connections on the Excel Data Tab to see what the Access connection is/was.  You could also re-establish a new connection to the Access query by going to Data>From Access>(Find Access DB on your computer/network)>Select Query from Access tables/queries, and reimport or establish a connection.

Anders, I checked: I only have one copy of the access file. So I could not be pointing to the wrong copy.

Tom, I am indeed trying to build a new connection. I am able to build the connection to most queries, but the query I am really interested in, is no longer visible from Excel.

Does the query reside in the Access DB?

See if this helps:

https://stackoverflow.com/questions/47564037/access-queries-are-missing-when-i-establish-a-connection-from-excel-using-get-d

Excel cannot "see" action queries and it may not be able to "see" queries that reference forms for parameters.  What change did you recently make to the query?

Tom, the link you provided does contain the correct root cause. I  added the nz function to the query and since then it became invisible to Excel.

You coulf try to replace the nz with an iff statement