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
Same story as the other 62 replies here. Can't refresh connections in protected sheets. September 2020, this issue is years old! Alex Lush
MicrosoftJonSov Hi,
could you please send us the Excel version you are using (Link for how to find your Excel version) and describe to us the exact scenario that happened to you?
Inbar
Excel Team
I also have this issue in Excel. Version is Excel for Office 365 MSO (16.0.12527.21296) 64-bit. If you lock a worksheet and have a query table on it, the query cannot refresh. You also cannot allow that option as it isn't in the list of checkboxes when enabling Protect Worksheet.
- Inbar_Privman
judremy Thank you for your response. Could you please add more information regarding the issue, are you referring to a protected workbook or a protected sheet? In a protected sheet you can not refresh by definition. In a protected workbook you can refresh if you choose to protect for structure.
Hi Inbar_Privman
In a protected sheet you can not refresh by definition. In a protected workbook you can refresh if you choose to protect for structure.Can I have some more detail on the above please? We should be able to protect the workbook and refresh queries if we choose to protect for structure only,? I am not finding this to be the case, I must be missing something.
I have queries to a MS SQL Database, import via Power Query. I would like to be able to protect the workbook and the model but have the user able to refresh the data. Any further thoughts?
