Forum Discussion

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

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
- 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
    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.
- Michael Stephenson
  Copper Contributor
  Nov 26, 2018
  Hi Guy,
  
  No, unfortunately my Office updates are managed by the system admin and I cannot update Office until they schedule updates for the entire group. I do not know when these will be scheduled.
  
  -Mike S
  - Guy Hunkin
    Microsoft
    Nov 26, 2018
    Michael Stephenson, I'd like to suggest that you speak with your IT on this topic then. Re-install should probably solve the issue for you.
    
    Guy
    
    - Excel Team
Guy Hunkin
Microsoft
Nov 13, 2018
Michael Stephenson, I am checking this. In a meantime please un-protect the sheet as a workaround.