Ask Your Question

Workbooks not automatically updating [closed]

asked 2012-06-09 20:44:23 +0100

shdawson gravatar image

updated 2012-08-12 13:54:11 +0100

tohuwawohu gravatar image


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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 21:51:42.043796

3 Answers

Sort by » oldest newest most voted

answered 2012-06-09 23:11:06 +0100

m.a.riosv gravatar image

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)?.

edit flag offensive delete link more

answered 2013-03-13 13:18:45 +0100

shdawson gravatar image

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

edit flag offensive delete link more

answered 2012-06-09 23:45:48 +0100

shdawson gravatar image

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

edit flag offensive delete link more


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

qubit gravatar imagequbit ( 2013-03-13 09:28:53 +0100 )edit

Question Tools


Asked: 2012-06-09 20:44:23 +0100

Seen: 168 times

Last updated: Mar 13 '13