No Automatic Updating of External Links

Hi! Suddenly I have to click a button every time I open my Calc program to activate my external links, why?
Never had to do that before? How can I make this to work automaticly every time? Jonas LibreOffice Version: 6.3.3.2
Windows 7

Please chose a short title for questions and avoid lengthy details within a title. Thanks in advance.

Hello,

because your security settings prevent from automatic updates of your external data. You need to:

  1. Set Tools -> Options -> LibreOffice Calc -> General -> Option: Update links when opening: [o] Always (from trusted locations)
  2. To set trusted locations: Use Tools -> Options -> LibreOffice -> Security -> Button: Macro Security -> Tab: Trusted Sources -> Category: Trusted File Locations -> Button: Add to add the directory of your file(s) which you want to trust to automatically update external links.

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.

1 Like

I cant belive its true, it worked haha. Fantastic, many thank. So Great…Mr KA II

NOPE DOESNT WORK

Was working now not anymore since last latest update Windows 11