View original (French)

LibreOffice Spreadsheet - Err:540

Solved
daddysnak Posted messages 974 Registration date   Status Member Last intervention   -  
daddysnak Posted messages 974 Registration date   Status Member 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 answers

  1.
    trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

    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
  2. daddysnak Posted messages 974 Registration date   Status Member 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
  3. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

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

    MBP + macOS Ventura
    OpenOffice, LibreOffice

    0
  4. daddysnak Posted messages 974 Registration date   Status Member Last intervention   15
     

    I just read it, but I don't see how I can restore the automatic connection to the other file ...

    0
  6. daddysnak Posted messages 974 Registration date   Status Member Last intervention   15
     

    The Automatic and Manual options in Refresh are not modifiable

    0
  7. daddysnak Posted messages 974 Registration date   Status Member Last intervention   15
     

    The clickable buttons are grayed out

    0
  8. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

    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
  9. daddysnak Posted messages 974 Registration date   Status Member 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
  10. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     

    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
  11. daddysnak Posted messages 974 Registration date   Status Member 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
  12. daddysnak Posted messages 974 Registration date   Status Member 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