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
Be aware, with a macro solution, that you may have to remove all checkboxes for 'refresh automatically when cell value changes ' for all queries in your workbook, and to refresh these queries with a command well from your macro. Similarly you will need to disable 'Refresh data when opening the file' and possibly also for background refresh. It is really a pain.
All,
I think if we want Microsoft to move and take some action to correct this, we need a lot more complaints in this thread than those of the few poor souls that are here now, who actually understand what is wrong. Suggest to mobilize your customers / colleagues to join in here.
- I logged a call with Office 365 a few days ago to determine if this was a bug or an intended functionality change. Watch this space. I cited this thread in the ticket hopefully they are seeing people's frustration!! I will update this thread as I hear more.
So I just checked the ticket I had logged on this with O365 support and it appears to have been closed without any response. Thanks Microsoft!
If anyone from MS Support is looking at this, the ticket number is #7854947, please reopen and provide a response. Thanks.
I'm trying to get a ticket raised on O365 support, but as I'm not the company administrator it's proving irritating.
