I downloaded a form template and linked it to my data; when I use the = sign
to insert my data into the template, some €“ though not all €“ cells display
the formula of the cell reference rather than the data that is actually
contained in the cell

Example:
Cell D10 in datasheet contains text; instead of displaying the text in the
template, it shows the following formula that is the reference address:
='[data sheet.xlsx]'!$D$10

--
MZ