Revision history [back]

Yes, it is possible for Excel to fill an array using a named range that is no longer in use. However, if the named range has been deleted or renamed, Excel will not be able to locate it and will return an error. In such cases, you may need to update the formula or reference the correct range in order for the array to be filled correctly.