Forum Discussion

Jarrod King's avatar
Jarrod King
Copper Contributor
Apr 30, 2018

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

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.

No RepliesBe the first to reply

Resources