Question: how to edit odc file?
Answer:  Open the ODC file that appears closest to what you're looking for. ...   In the Data menu, select Connections to review the embedded data connection file. ...   Edit the data connection. ...   Add the filter statement to the data connection. ...   Paste the resulting statement back into Excel and test the results.