What is the meaning of "Recalculation on File Load" in Options?

I am looking at that feature as I can’t make the program to bring a value in cell of file A from a cell in a file B. The value that is produced in file A is stubbornly “0” while cell in file B has value greater that “0”.

Edit your question and upload your file here. Anonymize the file beforehand.

It would take too much time to anonymize the file. I am giving up on LibreOffice and considering WPS Spreadsheet or FreeOffice 2018. Nevertheless, do you know answer to my title’s general question, regardless of a sample file presence?
Thank you.

The title question: It’s self-explanatory. Recalculate when loading the file. 1. For Excel 2007 and newer (files). 2. ODF spreadsheets saved by other programs (not LO). For 1. and 2. there is a choice: a) recalculate, b) never recalculate, c) ask users. What is not understandable?

Exampel: Write e.g. in cell B1 “= A1”, if in A1 the sought value is located.
It should show the same thing unless the formatting of the cells is different.

Thank you for the explanation. If one is using the program occasionally, it, the title wasn’t explicit.

In my case, value B1 was called from a sheet in a different file and the result was “0”, no matter what I did.
I succeeded once after I saved the source file with XLSX extension. However, when I tried to call data from the same file but from another cel (e.g., A2), B2 was “0” again.