I have had this problem like a year ago but now back again. I link cells from a source sheet. The link seems to work as I can see it maps back to source sheet. But the data does not show.
I have spent a good 30 minutes linking and unlinking. Tried to format the cells linked. Nothing shows even though if i hover I see cells linked to source file.