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

Resources