Forum Discussion
Solved
Can no longer refresh data in a Protected Workbook since Excel version 1803
Seems to have been a functionality change introduced in version 1803.
We have a protected workbook with some data connections to pull in data from SQL. Since updating to version 1803 the messag...
Hi there,
The fix was deployed for the following Office versions:
- Version 1803 (Build 9126.2196) and later
- Version 1804 (Build 9226.2135) and later
- Version 1805 (Build 9330.2017) and later
Hope this helps.
Guy.
- Excel Team
Guy Hunkin
Microsoft
MicrosoftJBreckeen, refresh of Power Query queries works if you protect the workbook structure. It will not work if you protect the worksheet. Hope it helps.
Guy
- Excel Team
Guy Hunkin Is there any way to override this? I want to protect most of a sheet that has a query in it, but allow users to edit certain cells.
- Guy Hunkin
Liz_wacoal , I am not aware of such a workaround. However, I suggest you publish your question at the General Discussion forum. Maybe someone will have a creative solution for you.
Guy
- Excel Team