Can no longer refresh data in a Protected Workbook since Excel version 1803

Guy Hunkin
Microsoft
Jun 04, 2018
Hi there,

The fix was deployed for the following Office versions:

Version 1803 (Build 9126.2196) and later

Version 1804 (Build 9226.2135) and later

Version 1805 (Build 9330.2017) and later

Hope this helps.

Guy.

- Excel Team
- 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
  - Guy Hunkin
    Microsoft
    Nov 25, 2018
    Hi Michael Stephenson,
    
    Can you please upgrade your Office version? This should be resolved in the latest semi-annual Office build version 1808 (build 10730.xxxxx).
    
    Guy
    
    - Excel Team
- 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
    Microsoft
    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.
- Alex Lush
  Iron Contributor
  Jun 05, 2018
  Thanks for the update Guy.
Petr Potociar
Copper Contributor
May 29, 2018
It seems to be working now (Version 16.0.9226.2156). Thank you for letting us know.

Forum Discussion

Can no longer refresh data in a Protected Workbook since Excel version 1803

Resources