Linking between workbooks

I have a collection of a dozen workbooks, all residing in the same directory, with many links between them.  Some are very large, so large that placing all the content within a single workbook would be less practical.

Because the number of rows is ever-growing, I cannot have a reliable system using any fixed range of cells for such references.  But of course referencing entire columns can be very slow, so I had been using dynamic ranges, experimenting with defining the size of the range in both the source and target workbooks, both as names or as a cell reference in a hidden sheet.  All of these methods have various issues and limits.

I landed on using Structured Tables as a more suitable method, and it indeed works very nicely.  Speed is very good, and of course the reference formulae are simpler and easy to read.  But now each time I open a workbook, I get an error, "We can't update some of the links in your workbook right now."

I had been under the impression that one of the reasons to switch to Structured Tables was specifically to avoid this error, which is easily avoided using direct cell references.  I'm wondering if it has to do with my formatting of the references, or if there's some method, such as still using direct cell references ($A:$A) on a structured table, which would get us around this error?

When viewing the Edit Links dialog, I can see it is reporting "Error:  Worksheet not found" for some of the links.  But as noted, all workbooks are located within the same directory, and the correct "Location" is listed when clicking on each source.  If I click "Update Values", it throws up a dialog with a list of sheets in each source, and once selected, it updates just fine.  Likewise, if I click "Open source", the source opens just fine, meaning any error stating the worksheet is not found is not correct.

Thanks!