Suddenly, from one day to another, I keep getting that annoying Error 540
whenever I try to get the cell value from another spreadsheet document.
First I open a spreadsheet document. The folder where the file is located
is included in Tools → Options … → Security → Macro Security … → Trusted
Sources → Trusted File Locations
Tools → Options … → Security → Options … → ☐ Block any links from documents
not among the trusted locations (see macro Security) is NOT checked.
Now I hit the New button to create a new spreadsheet file. I click cell A1
in that new spreadsheet, and I type ”=”, then I click cell L111 in the
other spreadsheet, the one I opened first. I then hit Enter.
A1 is now displaying ”Err:540”.
What am I expected to do to never see that happening again?
Err:540 means: ”*Happens if a function that requires (re)loading of
external sources is encountered and the user hasn't confirmed reloading of
external sources yet*”
No question whether I want to confirm reloading of anything came up, so
what am I supposed to do?
I had the same problem a few days ago and somehow it suddenly worked, but I
don't know what I did to make that happen, and not it doesn't seem to
matter what I do.
Do I also need to save the new spreadsheet file at some place included in
that Trusted File Locations?
Manjaro Linux 20.0.3
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Error 540 · Johnny Rosenberg
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy