Sometimes a Named Range may refer to an external sheet, or a button has
code assigned to it that resides in another spreadsheet. Could that be
the problem?