Forum Discussion
Can no longer refresh data in a Protected Workbook since Excel version 1803
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
I found this page describing the issue I am still having.
I have several Tables of Data on the Blue worksheets. There are tables on the Red sheets utilizing Queries from the tables on the Blue sheets. The Blue sheets are protected with no issues.
But the attached .png shows the issue I am having when I protect the Red sheets. I have tried enabling different amounts of protection, but as soon as I put any protection on the Red sheets I get the error. This happens when there is not even a change in the source data.
It seems the same issue that others were having above, but my version is newer than the fixed build. Did this issue reappear? Or is this something new?
Thanks in advance,
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
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
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.
