On Thu, 23 May 2019, Stephen C. Camidge wrote:

I have 2 spreadsheets that are linked, but unlike the behaviour in Excel,
Libre Office will not refresh the links automatically when I make a
change. I have set the preferences under Calc Tools and under Macro
Security  to refresh. This allows undates when the file is opened.

How do I get automatically refreshed links when both files are open?

Steve,

Automagically? I don't know. However, I get Excel spreadsheets from clients
and regulators and immediately save them as .ods files. When I open one that
has links among the tabs a dialog box opens asking if I want to upgrade the
links. Since it does no harm I usually let it do so.

What version of LO are you running? Mine currently is libreoffice-6.2.3 on
Slackware-14.2. But, this behavior has not changed as far as I can remember.

Also, consider posting on the LO mail list: List-Subscribe:
<mailto:users+subscr...@global.libreoffice.org>

Regards,

Rich
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to