View original (French)

LibreOffice Spreadsheet - Err:540

Solved
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   -  
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   -

Hello,

In a table, a result comes from 2 sources in another table.

However, I receive the code Err:540

Note:

This code first appeared at the end of September, whereas the operation has been carried out at the end of each month without any issues... since the end of January.

Thank you for your responses,

11 réponses

Réponse 1 / 11
trotte-menu Posted messages 892 Registration date   Status Membre Last intervention   342
 

Hello,

What happened since the end of September?

Did you go check the Error Codes:

540
External content disabled
Occurs if a function requires reloading or loading external sources and the user has not yet confirmed the reloading of external sources.

MBP + macOS Ventura
OpenOffice, LibreOffice
0
Réponse 2 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

I do have the indication that ...

The automatic update of external links has been disabled.

What did I do? (or not ...) to disable this link?
And how can I reactivate it?

0
Réponse 3 / 11
trotte-menu Posted messages 892 Registration date   Status Membre Last intervention   342
 

See in the Edit menu --> Links to external files.

MBP + macOS Ventura
OpenOffice, LibreOffice
0
Réponse 4 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

I just read it, but I don't see how I can restore the automatic connection to the other file ...
0
Réponse 5 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

The Automatic and Manual options in Refresh are not modifiable
0
Réponse 6 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

The clickable buttons are grayed out
0
Réponse 7 / 11
trotte-menu Posted messages 892 Registration date   Status Membre Last intervention   342
 

After re-reading the title of your question, are you using Excel with LibreOffice (or OpenOffice)? without saving in .ods format?

If it’s a Calc spreadsheet, it is important to call things by their name.

Not all ballpoint pens are Bic's.

MBP + macOS Ventura
OpenOffice, LibreOffice
0
Réponse 8 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

Hello Trotte-menu ... and my apologies.

Since yesterday morning, I haven't had the chance to go on the computer. I have a wife who is suffering from Alzheimer's disease, and I have to take care of her constantly. I only have a little free time in the morning...

But above all, I indeed made a mistake in the title.

I exclusively use LibreOffice (version 7.5.2.2). Is it possible to change the title of my post?

Thank you for your reply and your patience.

The future belongs to those who wake up early!
0
Réponse 9 / 11
trotte-menu Posted messages 892 Registration date   Status Membre Last intervention   342
 

Hello,

See here for the continuation of the responses to a resolved topic concerning error 540 that might interest you.

MBP + macOS Ventura
OpenOffice, LibreOffice
0
Réponse 10 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

I just read this series of questions and answers, but I don't see how to re-enable the automatic linking of external links that has been disabled.
0
Réponse 11 / 11
daddysnak Posted messages 974 Registration date   Status Membre Last intervention   15
 

Eureka ... and as simple as pie ...

In the destination file, all I need to do is click on allow updates ... which concerns updating the links ...

0