Forum Discussion

Alex Lush's avatar
Alex Lush
Iron Contributor
Apr 04, 2018
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...
excel
office 365
  • Guy Hunkin's avatar
    Guy Hunkin
    Jun 04, 2018

    Hi there,

     

    The fix was deployed for the following Office versions:

    1. Version 1803 (Build 9126.2196) and later
    2. Version 1804 (Build 9226.2135) and later
    3. Version 1805 (Build 9330.2017) and later

    Hope this helps.

     

    Guy.

    - Excel Team

David Brander's avatar
David Brander
Brass Contributor
Apr 11, 2018

I have this same issue, the only work around I've come up with so far is to use a macro to run when the workbook is opened, unprotect the workbook, refresh the data (not in the background) and then lock the workbook.  It's a pain in the arse since I have to change many different tools.  Please roll this change back! 

Andrew Nevard's avatar
Andrew Nevard
Copper Contributor
Apr 13, 2018

Yes this is a big problem. 

 

My query is refreshed using VBA.  I use a class object for the query so it can run in the background and trigger events.  My workaround is to use the BeforeRefresh event to unlock the workbook, and the AfterRefresh event to lock it again.  I have not tried to see if these events are triggered when a user selects Refresh All from the data ribbon. 

 

Of course I do have to update all the workbooks that I have deployed!

 

Resources