How to make calc cell links update automatically again?

[solarbruce]

Recently upgraded, have 2 spreadsheets, one has one cell “linked” to a cell in the other.

How they were linked:

Linked by using = in a cell, and then clicking on the cell needed to link to in the other (source) spreadsheet.

also tried

Copied cell from source spreadsheet, and then paste special into the destination spreadsheet cell.

I’ve linked OLE object spreadsheets into a document, and in the past, these linked spreadsheet would automatically update as they were opened by the document, so current data was always inserted.

Now, after upgrading, no automatic updating occurs, and when I choose [edit]>[link], the manual option is selected, and both the manual and automatic options are dimmed and disabled.

FYI, have gone into [tools][options][calc][general} and set “update links when opening” to always.

Even rebooted PC after to no avail.

Any help to set these links to automatically update will be appreciated, have invested a lot of effort into this for work purposes.

[solarbruce]

Looks like this is either too simple or too tough?

[Miroth]

Try the DDE function, see
https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-GB&System=WIN&Version=5.1#bm_id3154680
if you are linking a cell in one spreadsheet to one in another spreadsheet this will work and will update automatically in both are open and you change the source cell value.
If you want to break the link later, go to edit\links.
Hope this helps