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
May 03, 2018

Hi,

 

It is a known regression and we are working on a fix. Stay tuned and follow up the updates on Tech Community.

 

Guy
- Excel Team

  • irisw's avatar
    irisw
    Copper Contributor
    May 05, 2020

    Guy Hunkin I just tried doing this in my excel sheet right now 5/4/2019 and it still doesn't work. Once I protect my worksheet, it no longer allows me to refresh. 

    • Guy Hunkin's avatar
      Guy Hunkin
      Icon for Microsoft rankMicrosoft
      May 13, 2020

      irisw ,

       

      Please provide more details about your Excel version and your exact scenario.

       

      Guy

      - Excel Team

  • David Brander's avatar
    David Brander
    Brass Contributor
    May 03, 2018

    Thank you Guy! :) Please keep us updated.  

     

    David

    Guy Hunkin wrote:

    Hi,

     

    It is a known regression and we are working in a fix. Stay tuned and follow up the updates on Tech Community.

     

    Guy
    - Excel Team

     

    • Alex Lush's avatar
      Alex Lush
      Iron Contributor
      May 10, 2018

      Guy Hunkin- many thanks for your update.

      I did finally receive an update to the ticket I logged through O365, although the information directly contradicts what Guy has said in this thread!

       

      [Ticket #:7973974]

      Hello Alex,

      This issue is by design and even Out of Support for Office 365 Technical Support.
      You may share your valuable feedback for this on the below support links - 

      https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32287204-enable-data-query-refresh-with-powerpivot-tables 
      https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/34126504-sql-queries-won-t-refresh-on-protected-workbook-si 

      Should you have any additional queries, please let me know.

      Thanks
      Ankit Shukla
      Microsoft Office 365

      CwsRequestId:7438ad61-ee11-4d5f-a9de-af58cf7fa14a

Resources