I have the following function
=INDIRECT((CONCATENATE("‘file:" , $Constants.B3 , "’#$Masterlist_2025.",$Constants.B1,":",$Constants.B2)))
which works. I made the file and boundaries variables as the source comes from another person and needs to be a bit flexible.
The problem I’m having is that if I change B2 to a smaller value the cells that are now outside the scope of the new boundary show as #NA. Likewise when add rows or columns (changing B2) they don’t show up. It seems that the original size is fixed. Any way to change that?