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 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

David Brander's avatar
David Brander
Brass Contributor
Jun 06, 2018

Hi Guy,

Thanks for the fix, however it now appears something else has changed to do with queries. In our documents we're using we have an Excel file connection that pulls some data in that is centrally updated, in versions up to the latest this seemed to work fine. Now it appears the latest version of Excel won't allow us to refresh that connection and asks for a Microsoft Access Database Engine OLE DB Initialization Information. 

 

I tried replacing the query using the latest version of Excel, and it works fine, until you try opening the document with an older version of Excel and I get this error: 

 

 

 

 

Any ideas for a fix? I seem to have one version that works on older versions (e.g. 2010) and one that works with the new version of Excel 365 v1805 build 9330.2087.

 

Thanks,

David

 

 

  • Guy Hunkin's avatar
    Guy Hunkin
    Icon for Microsoft rankMicrosoft
    Jun 07, 2018

     

    Hi David,

     

    I am not sure I understand your scenario. Are you saying that you have a query that cannot be refreshed with an older Excel version anymore?

     

    Can you please provide step-by-step instructions for us to repro the problem locally? I will also appreciate if you can share a problematic workbook with me? Just make sure to remove or scramble all the sensitive or private data before sharing your workbook.

     

    Guy.

    • Troy Du Plessis's avatar
      Troy Du Plessis
      Copper Contributor
      Jul 24, 2018

      Hi,

       

      Easy fix. Just protect sheet and workbook with new password of ur choice and then unprotect again...should be all sorted.

       

      Regards

Resources