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

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
  - MrJoeM
    Copper Contributor
    Jun 27, 2019
    Guy Hunkin I am seeing this behavior on Excel 1808. 10730.20348 Click-to-run
    
    Is there a hot fix or other patch required?
- Guy Hunkin
  Microsoft
  Nov 13, 2018
  Michael Stephenson, I am checking this. In a meantime please un-protect the sheet as a workaround.
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.
  - 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
Alex Lush
Iron Contributor
Jun 05, 2018
Thanks for the update Guy.

Forum Discussion

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

Resources