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

Michael Stephenson's avatar
Michael Stephenson
Copper Contributor
Nov 08, 2018

Hi Guy,

 

I am still running into the same problem. I am running Excel version 1803, build 9126.2295 (see below).

 I am running a basic query between two Excel workbooks on the same network. When the sheet I want to update is protected (default protection settings), I receive the below error.

 

Edit: to clarify that I receive the error message when selecting "Refresh All", in case that wasn't clear.

 

Any advice?

 

Thanks,

 

Mike

 

 

Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
Nov 13, 2018

Michael Stephenson, I am checking this. In a meantime please un-protect the sheet as a workaround.

Resources