Is it possible to make a cell’s value linked to the data in a TXT file, e.g.:
A1= line 1 of file1.txt
A2= line 2 of file1.txt
A3= line 3 of file1.txt
If the value in the TXT file changes, then the Calc document is opened, then the cell value would change.
Is this possible?
Open the TXT file from calc, on the import dialog disable all separators, a new spreadsheet should open with a line by row.
Copy the first cell of this file in the destination file, using past special [Shift+Ctrl+V], mark link and Ok.
A link to the first cell in the TXT should be there, now you can close the TXT file and copy and past or drag the formula down.
This can be done with a large range of TXT file, a matrix link with the range it’s pasted. Play a bit to find your way.