I have a worksheet that is set to automatically update from another
database whenever I fire Excel up.

I set it and it works. Then without any further interference from me
when I go to it, it does not update, warns me re macros that;'s all.
Opens up.... no amendments.

When I go to check the setting I find that in Data, all except 'Data
range properties ' are greyed out so I cannot reset the feature. Other
worksheets in the same I could reset them for updating but obviously
that does not effect the sheet I want updating.

John