Refresh All on Protected Work Sheet

[David M Wright]

Hi Folks,
I use Access to extract relevant data via queries and create tables. Excel then retrieves the data from the tables made in Access (via the ‘Data – Import External Data – Import Data’ method). I use Excel’s ‘External Data’ Toolbar to ‘Refresh All’ in the Excel workbook. I have formula on several worksheets which I would like to protect from accidental changes. THE PROBLEM IS:- If I apply protection (‘Tools – Protection-Protect Worksheet’), the ‘Refresh All’ control on the ‘External Data’ Toolbar does not work.
If anyone knows how to resolve this problem I would be very pleased to hear from you and exceedingly grateful. I am not an expert in Excel and so will probably need step by step explanations of how to carry out whatever suggestions you kindly offer. David M Wright

[David M Wright]

Bump no response