Answer
This has been resolved in a confirmed case by exporting the migration job and re-importing it — re-importing regenerates the migration job's underlying generated APIs, which cleared up the metadata retrieval error. If the Excel Add-in fails with this kind of error on a migration job that references a custom-field view, try an export-then-reimport cycle on that migration job before assuming something is fundamentally wrong with referencing the custom-field view itself.