This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a workbook which is linked to several data sources.
I want to be ableto protect one or more sheets so that all end users view the sheet the same (e.g stop colums widening etc).
But when I do it fails to be able refresh data on that sheet?
ANy ways round this I dond't see it on the list of options when you do prtect with password.
Trevor
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi, you can add a buttom to the spreadsheet where you link a macro which will unprotect your sheet first then refresh it and protect it again