Workbooks not automatically updating

[shdawson]

Hi,

Have some workbooks that are linked. I have calculations of “Update When Opening” set to automatic. The links are reflecting manual in Edit/Links.

What needs to happen to get the calculations to automatically update, please?

Control+Shift+F9 is also not making the refresh of the calculations. Is the link broken?

Thanks,
S

[mariosv]

To get some help better detail:

• The Operating System
• The LibreOffice version.
• The type of the files, Ods, xls, et.

Is updated in Menu/Edit/Links/Update (selecting the file to update)?.

[shdawson]

Yes, I do see that in the menu. Thank you. However, it says Manual. The calculations are not happening consistently.

Is there another setting that needs to be considered?

Thanks,
SHD

[qubit1]

@shdawson – Have you found an answer to your problem? (perhaps another config setting?)

[shdawson]

Yes, Control+Shift+F9 works. However, it would certainly be nice to have links across workbooks automatically update. Is there a way to achieve the later, please?

Thanks,
SHD