I have an Excel workbook that references another Excel workbook for data validation lists. Instead of having both workbooks open, I use Microsoft Query to pull the external Excel table into the current workbook using data refresh. The problem is that the folder that holds the Master Data is pretty sensitive and we do not want people having more than Read only privilages. Only people with Read/Write access are able to refresh properly while those with read only access get an error saying "Unexpected External Database Driver Error ()". How can I make the refresh work for those with Read Only access work properly?