I have five table queries from separate workbooks added in seperate worksheets in my master file. Four of these queries seem to be working fine. But everytime I press 'Refresh All' I get the error message "We couldn't get the data from 'Name of query table 5' in the workbook 'Location where original table 5 is saved'. Open this workbook in Excel and try again." When I open the original workbook with table 5 and press 'Refresh All' again, the error message doesn't show.
I have already tried all the suggestions for solutions I could find online and none worked, e.g. Data > Queries & Connections - there are no Connections shown. What else could be the problem?
