I have 2 separate .ods files and I want to link the data between these 2 files. In excel it’s easy as clicking the cell in the 1st file and typing ‘=’ and click the cell on the 2nd file and they are already linked. Any changes in the 2nd file reflects on the 1st file. Trying to achieve this in libreoffice seems to be a bit different.
and please tell us, what exactly is different?