I have imported data in my workbook for which I have selected "update data when the file opens". I have also protected the worksheet so that other users can't make changes to the tables/data. But now when I open the file, the data won't refresh because the worksheet is protected. Is there any way to allow the data to refresh on startup and still keep the worksheet protected?
Bookmarks