Hi Sir,

After some search, I found that it is true that Excel will not accept a reference to a dynamic named range in a closed workbook. Otherwise, this will lead to such warning message as below:

Microsoft Excel cannot find 'MIPS' on "Data.xlsx". There are two possible reasons:

The name you specified may not be defined.
The name you specified is defined as something other than a rectangular cell reference.
Check the name and try again.

My question is: how to use some Excel macro or available setting to suppress this kind of warning message?

I have a file which is linked to the dynamic ranges of many external links. Every time this warning message pops up when there is such issue and I have to manually dismiss the warning message before the file update can continue. For this problem, I have to sit in front of the computer for 1 hour. Because the external files with dynamic ranges are made by my colleagues, I cannot change their file. The only thing I can do is to ask Excel to ignore these warning messages and just do the update as much as possible automatically.