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

Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
Jun 30, 2019

MrJoeM, can you please share a screenshot of your Excel version? Go to File > Account > take a screenshot of everything that appears under Product Information on the right (remove your email address for the sake of privacy) an paste it in your reply to me.

 

Thanks,

Guy.

  • Guy Hunkin's avatar
    Guy Hunkin
    Icon for Microsoft rankMicrosoft
    Jul 14, 2019

    Hi MrJoeM ,

     

    I am unable to reproduce the problem locally. Can you share the problematic workbook with me please and a video recording of the scenario? Make sure there is no sensitive or private data in your workbook though.

     

    Guy

    - Excel Team