I have a spreadsheet that consists of two worksheets. One worksheet queries and external datasource using MS Query and the second sheet then queries the first again using MS Query. The spreadsheet has a password applied to prevent it being modified by un-authorised users. The reason for this is that it is accessed by many users in my organisation and this prevents them overwriting any formulas etc.. but still allows them full data manipulation rights. They just can't overwrite the original.

The problem that I am having is that if I open the spreadsheet and input the password and refresh the data queries then it works fine. If however I open as read only then the first sheet that queries the external data source works correctly but the second sheet seems to refresh but does not bring through the updated information that appears in the first sheet.

Has anyone got any ideas of how to get around this?