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

Miroslaw Magierski's avatar
Miroslaw Magierski
Copper Contributor
May 22, 2018

Same problem here.

 

If it's a feature and not a bug (which I'm really hoping is not the case) then I'd like an option to not use it. I honestly can't see what benefit would there be to having it work like that.

David Brander's avatar
David Brander
Brass Contributor
May 22, 2018

Above, Guy Hunkin suggested that it isn't a feature and the team is working on a fix.   Guy - do you have any update? 


Thanks,

David

  • Nicolaj Lefevre Grumstrup's avatar
    Nicolaj Lefevre Grumstrup
    Copper Contributor
    May 28, 2018

    The problem seems to be solved now. I don't get the pop-up anymore when I open the workbook. 

    Is it the same for you? 

     

    Kind regards

    Nicolaj

    • Guy Hunkin's avatar
      Guy Hunkin
      Icon for Microsoft rankMicrosoft
      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

         

         

    • Petr Potociar's avatar
      Petr Potociar
      Copper Contributor
      May 29, 2018
      It seems to be working now (Version 16.0.9226.2156). Thank you for letting us know.

Resources