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 message 'Workbook is protected and cannot be changed' appears when trying to refresh the data. Removing workbook protection allows data to be refreshed.
Using the same workbook in version 1802 allows the data to be refreshed with the workbook protection left on.
Posting here in case anyone else experiences this issue.
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
