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
This is a major problem. Everybody vote this thread up and send complaint to Microsoft helpdesk.
Coded workbooks are usually used by a lot of people, and then suddenly production halts. Not fun.
A problem with the solution to open/close workbook:
If the code have to unprotect/protect for every data read, this takes time to run (since it decrypt/encrypt the workbook), making for a lesser user experience.
If this is intentional by Microsoft, at least there should be an option to toggle the new functionality of "protect workbook" on/off.