Error 540

classic Classic list List threaded Threaded
1 message Options
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Error 540

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?

LibreOffice 6.4.5
Manjaro Linux 20.0.3


Kind regards

Johnny Rosenberg

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy