in libre calc - in the source file I assigned a name to a cell which has a formula. When I linked this named cell to the target file by external data, I get the formula in the target cell. I want the result of the formula to appear in the target cell.

edit

(You might try next time to find a more concise though incisive subject. The fully worded question comes then next in another place.)

There is a probably related bug tdf#61743. The original reporter was myself but it was one of my early attempts, and I didn't a good job.

The original claim of that bug was that named ranges (may be single-cell ranges) do not work with relative path-saving. Later the aspect you mentioned came into sight. There is a recent (2017-04-19) comment #12 by Eike Rathke making an assumption about the background. The bug is still not assigned. You may try a kind of bump adding to that bug.

( @erAck )