Worksheet Protection & External Data Refresh

Question

Using Excel 2016.&nbsp; I have tried to protect individual worksheets within my workbook to prevent external data refresh from updating those particular worksheets while it should be allowing the update on others, but the worksheet protection does nothing, all sheets update regardless.&nbsp; The protected cells are locked and unable to be selected.&nbsp; So why are they still updating and how do I stop it?&nbsp; Many thanks for your assistance!

jkpieterse · Answer

I guess a better way is to write a bit of VBA that refreshes the connections you want refreshed.

toni silver · Answer

Thank you for the response, but I'm confused.&nbsp; Shouldn't external updates not happen at all if the worksheet is protected?&nbsp;

jkpieterse · Answer

Probably, but as you said that does not work I was suggesting an alternative path :-)

toni silver · Answer

LOL, understood.&nbsp; Thank you for the suggestion, which probably won't work for the more basic users who will be using this particular workbook.&nbsp; However, I might be able to make it work by changing the workbook to a manual calc.&nbsp; Extra work for them, but they're causing extra work for me, so I guess we're even.&nbsp; ;)

jkpieterse · Answer

I forgot to ask: what kind of "External updates" are you referring to?

Forum Discussion

Worksheet Protection & External Data Refresh

5 Replies