External Data wont refresh on a prtected and shared workbook...

I have a workbook that is used by multiple people over a network. In this
workbook I added some data from a site that i wanted refreshed everytime the
workbook is opened. I found out i can't protect the worksheet or protect and
share the workbook and still have it refresh the data. Is there a way to
protect/share the workbook (due to code inside the book) and still have the
external web data refreshed upon the book opening