I have a query on the workbook that contains the query. The file (xlsm) is also password protected. When I don’t have the password on the file the query works when i reinstate the p;/w the query hangs .
What are my options. The most sensitive tab is a salaries tab.