SQL queries won't refresh on protected workbook since last update

Copper Contributor

Hi Microsoft,

Since the last Excel Update, SQL queries will not refresh on a protected workbook. This causes multiple issues as the basis of a lot of excel modelling is pulling information from multiple sources. Basically this has corrupted a number of reports and models I have in excel. It is standard practice to allow users to ‘refresh’ model information but keep the file protected from tampering. As far as I can see, this is a bug as Workbook protection is only on structure and refreshing a SQL extract is not altering the structure in any way. Please can this be looked into as this has caused multiple issue in our organizations reports and models. If you have a work around can you also please let me know.

0 Replies