Excel worksheet Notes of Failure/Warning cells show #NAME?

[weedee77]

After pressing 'Refresh Data' button I went to a AAD App Migration Report tab.

All cells under C-column 'Notes of Failure/Warning' display #NAME? instead of describing the issue.

How this can be fixed? Report has no value if there is no further information available about the issues detected

[edvrfn]

This is still an issue in 2021